In the not so distant future, companies will be run by a monolithic AI algorithm. Until that time, it is up to us to architect elegant and superlative solutions to empower our company to make the best decisions possible.
We are all familiar with import and DirectQuery as query modes for Analysis Services and Power BI semantic models. However, with the release of Microsoft Fabric, there is a new kid on the block - Direct Lake!
Learn how to automate the processing of tables/partitions which need to be processed in your model.
Learn the importance of enabling XMLA Read/Write
Report Analyzer now has a recommendations engine for report best practices!
A productivity tool for analyzing a Power BI report's performance.
Learn how to easily export metadata of visuals, filters and other objects within your Power BI report.
Easily overcome a potential data source issue when migrating to Power BI Premium.
From automation scripts for Tabular Editor to DAX patterns and Direct Lake migration.
I specialize in business intelligence and analytics with a focus on Analysis Services, tabular modeling and DAX. Having architected Microsoft's internal best-in-class data models used by 30,000+ people, this blog is where I share techniques for building elegant, performant and scalable models.
