Did you know that you can use Power Query as a data profiling tool? While the great majority of Power Query (M) functions are centered
Tag: M
Design Mode in Power BI Desktop
Design Mode in Power BI Desktop To better support large Power BI datasets with many tables, DAX measures, and potentially complex M query expressions, it
Query Detail Rows in Power BI
Detail Rows in Power BI Let’s say you have an Analysis Services 2017 (1400 CL) model and you’ve implemented several detail rows expressions to help
Detail Rows Documentation
Detail Row Expressions Detail row expressions is one of the top new features of Analysis Services 2017 (1400 Compatibility Level) as it provides the equivalent
SSAS Tabular 2017 Partitions
SSAS Tabular 2017 Partitions Incremental data refresh is not yet available to support large Power BI datasets. It’s on the Power BI Premium Roadmap, but,
Boston Code Camp M Query Materials
Earlier today I presented M Query Fundamentals at Boston Code Camp 28. The following zip file contains the supporting PowerPoint slides from this session and