One of the important tasks as a Power BI administrator is to ensure compliance and auditing requirements of shared reports. The Scanner API and the activity log can give us many really good insights, but… Read More »Widely shared Power BI reports
A long wish have come true. It’s now possible to query the Admin APIs and get a list of all the tenant settings. This is very valuable to be able to document the settings and… Read More »Extract and query the tenant settings
There has been a lot of hype around the newly announced Microsoft Fabric – the marketing machine surely did a very good job! But what if we take a look behind? Is this really as… Read More »Is Microsoft Fabric just old wine in new bottles?
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
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
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
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
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
Microsoft Graph is the gateway to data and intelligence in Microsoft 365 and comes with REST APIs so we can extract data from a long range of Microsoft cloud services like Microsoft 365 core services and… Read More »Extracting Microsoft Graph data with Data Factory
You can now get the list of users as part of the WorkspaceInfo API. You just extend the PostWorkspaceInfo API call with getArtifactUsers=True. Much easier and also give you user details on datasets, reports etc.… Read More »Extracting Power BI metadata with Data Factory (part 2)