Power BI roles
When doing training and sessions on conferences, it’s very important to beware who the primary audience is. Maybe only who specific role or multiple roles? Here is the 8 roles, that we have come up… Read More »Power BI roles
Extension to the Scanner API
Microsoft just announced that the Power BI admin Scanner API (WorkspaceInfo) will now include even more valuable metadata such as scheduled refresh settings and RLS configuration. The Scanner API is where you can get a… Read More »Extension to the Scanner API
Why do I attend SQLBits?
I had the question come up a couple of times. Why should I attend the SQLBits conference – what are the things I should say to my boss, so she would let me go? And… Read More »Why do I attend SQLBits?
Next Step Power BI Tabular model development
I’m co-presenting a full day training at SQLBits 2023 about how to switch from Power BI Desktop to Tabular Editor. Going from a Dataset to a real Tabular data model. Tabular Editor is a tool… Read More »Next Step Power BI Tabular model development
Query Power BI activity events with Synapse Serverless SQL
This is a natural extension to my post about how to query the Power BI tenant metadata. The JSON data output from the “Get Activity Events” REST API (Power BI Audit Log) is much more… Read More »Query Power BI activity events with Synapse Serverless SQL
Catalogue of Power BI training modules
Orange Man and Ásgeir Gunnarsson have developed a full catalogue of no less than 63 training modules in Power BI. All the modules are focused on best practices with hands-on exercises and are based on many years of practical… Read More »Catalogue of Power BI training modules
Query Power BI tenant metadata with Synapse Serverless SQL
As a natural follow-up on my last blog post about using Synapse Analytics to extract a complete tenant catalogue of Power BI metadata I will now show how to use the power of the Serverless… Read More »Query Power BI tenant metadata with Synapse Serverless SQL
Extracting Power BI tenant metadata with Synapse Analytics
All the Data Factory templates that comes as part of my Power BI Monitor GitHub repository can already easily be imported and used with Synapse Analytics. So, why do I now create a new one?… Read More »Extracting Power BI tenant metadata with Synapse Analytics
Traditional Modern Data Warehouse on GitHub
Two years ago I started writing a blog post to present this concept I came up with as part of my consulting, presentations and training. It’s really nothing fancy – it’s just a simple architecture… Read More »Traditional Modern Data Warehouse on GitHub
Community sessions added to GitHub repo
I finally found the time to add all my community sessions to a public repo on GitHub, so that the slides is easily accessible for everyone in PDF format. It’s been quite a trip down… Read More »Community sessions added to GitHub repo