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

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

This is still one of the most common dataflows questions: what’s the difference between Power BI dataflows and Power BI datasets? For the last year I have resisted tackling this question head-on. This isn’t because it’s a bad or „dumb“ question. Just the opposite – this is a very simple question, and the simpler a […]

über Power BIte: Dataflows vs. datasets — BI Polar

If you’re a frequent reader of this blog, or a frequent user of Power BI dataflows, you probably know these things already: Power BI dataflows are workspace-level objects in the Power BI service that enable data reuse through self-service data preparation. Power BI dataflows store data in the CDM folder format in Azure storage. CDM […]

über Importing model.json to create a new dataflow — BI Polar

 

The reaction to this recent post on lineage and Power BI dataflows highlighted how important lineage is for Power BI[1]. Although (as this post shows) there are lineage user experiences in place for dataflows today, and experiences coming for all artifacts in a workspace. Even with these new experiences, there will still be times when […]

über Governing Power BI just got a little easier — BI Polar

When asked what content our blog readers and video viewers would like to see more of, the most requested topic is: „Industry Best Practices“. With that in mind we will be starting a series of Blog posts and Webinars by our MVPs highlighting work they have done. The first in this series is by Ike […]

über Creating Updateable Power BI Reports with PowerApps by Ike Ellis — Sterlings

There are a lot of discussions these days around Power BI tools to create reports and for sure many of you may have already downloaded and worked with some of them if not all of them. You may also already thought that some of the tools’ names are confusingly similar. I recently had an interesting…

über Power BI Ecosystem Report Authoring Tools Demystified — Business Intelligence Insights