How to open a complex JSON record in Power BI and Power Query
Easy way to expand a complex JSON record without loosing the information that is visible already. Works for star schema and for big flat table
Power Query (M)agic Part 2: Organizing Your Queries - PowerPivotPro
Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.
Basics of M: Power Query Formula Language | RADACAD
Running a native query within an M project | Ambiguity vs Information
A few weeks ago, Microsoft published the Power Query SDK, an extension of Visual Studio, on the Visual Studio Marketplace. It is available for free for VS2015 and VS2017. This extension is a really…
Chapter 9 – Advanced Queries and Parameters | Paul Turley's SQL Server BI Blog
This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports. Eac…
Exporting Power Query/M Queries To ODC Files In Excel 2016 Get & Transform – Chris Webb's BI Blog
A really useful new feature was added to Get & Transform (the functionality previously known as Power Query) in the latest updates for the Office 365 click-to-run version of Excel 2016: the abi…
Power Query (M)agic Part 1: Always Have Good References - PowerPivotPro
Power Query (or PQ for short) is one of the cornerstones of the Microsoft BI Suite. It’s a tool built into Excel 2016 and Power BI Desktop that allows us to extract our data...
Navigating over 600+ M funcitons | Query Power 📊
Whenever I’m faced with a data mashup problem in Power BI, I try to check if it can be resolved with a standard M functions exposed by the intrinsic variable #shared. Navigating this data str…