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)
Ok, this might be a clickbait title, but nonetheless – you can actually save money if you buy Power BI Premium capacity as a replacement for hosting your models on Azure Analysis Services. This is… Read More »Save money with Power BI Premium Gen2
As a natural continuation on my latest blog post on Extracting the Power BI activity log with Data Factory i will now share how to extract all the metadata of your Power BI tenant. Information… Read More »Extracting Power BI metadata with Data Factory (part 1)
If you want to follow along and get an understanding how your Power BI tenant is used, then it’s crucial to get your hands in all the activity events in the Power BI Audit Log.… Read More »Extracting the Power BI activity log with Data Factory
With the December 2020 release of Power BI Desktop we got an early christmas present. A loooong waited feature that will change how we build Power BI solutions! The feature is called “DirectQuery for Power… Read More »Understand the queries behind Composite Models
Big data, Databricks and now also Synapse Analytics. Microsoft really focuses on how to put together BI and DWH solutions that can handle huge volumes of data. But what about the “ordinary” solutions in the… Read More »The traditional modern Data Warehouse
The background for the Power BI Quiz is quite simple. I misses hanging out with new and old Power BI friends at community meetings and conferences. And then simply having some fun ? I have… Read More »Power BI Quiz. Who, What, When, Where, Why, How?
Ohhh no. Another Power BI feature that requires Premium. I know this feeling. A lot of small and medium sized companies don’t have Premium – they simply can’t afford it. With less than 500 users… Read More »Using the XMLA endpoint without Premium
There has been a lot of fuss around XMLA endpoint in Power BI since the announcement by Christian Wade at Ignite 2018. Firstly Microsoft opened up the endpoint for read access and finally now, as… Read More »Use cases of the XMLA endpoint