This is a series of posts and exercises from a recent full-day workshop called Next Level Power BI. Check back for additional lessons and freely post your questions and feedback in the comments section after this post. Power Query is a modern data acquisition and transformation technology and it is the „Get Data“ component of Power BI and many other Microsoft tools. The query script language of Power Query is known as „M“ or the Microsoft Data Mashup language. The menu options and selections in the Power Query Editor interface build this „M“ script for you but to use Power Query at an expert level, you must understand fundamental concepts of the language. The post will step you through some essential mechanics of the language to build the necessary fundamental skills.

über Next Level Power BI – M Language Basics — Paul Turley’s SQL Server BI Blog

Business Central SaaS Exporting Database Backup and Restore it on your Sql Server Since some days, Microsoft has activated the feature for downloading a backup… 587 weitere Wörter

über Business Central SaaS Exporting Database Backup and Restore it on your Sql Server — Roberto Stefanetti NAV & Business Central Blog

News, News, News

Also ganz ehrlich, was da heute alles an Neuigkeiten pupliziert wird, ist ja schon fast beängstigend.

Wow to many news. Very hard to keep track. Here we go:

Microsoft Ignite 2019 News pdf download

Announcing Azure Synapse Analytics

Microsoft Power Platform News

Azure Data Factory Wrangling Task (No in public preview)

SQL Server 2019 GA

 

Announcing Visual Studio Online Public Preview

 

 

 

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI datasets: https://blog.crossjoin.co.uk/2016/07/08/excel-2016-pivottable-mdx-changes-lead-to-big-query-performance-gains/ I know it sounds boring and not something you need to worry about but trust me, this is important – […]

über Excel PivotTable Query Performance With Analysis Services, Power Pivot And Power BI (Revisited) — Chris Webb’s BI Blog