PBI Usage Logs

[mtitsworthsfmfb]

With the introduction of Fabric, wondering if there is a more straight forward way of pulling usage data into a dataset (like a lakehouse). Going the PBI logs REST API route seems onerous for a pretty standard request. Might there be a connector in development with data flows?  

Maxwell 

[mtitsworthsfmfb]

This is great, but I'm still surprised there is no OOTB solution from Microsoft on this topic. 

[Miszel8 · Accepted solution]

Hello,
AFAIK you must go for Power BI REST API and GRAPH API if you want to add the licence/entra groups information.

The good news is I've created a completely automatic solution to gather all of this data on the daily basis, historise it in the small dwh and display the results in Power BI report -> all of the needed items are in the Git Repo.  All you need to do is to deploy it.

You can deploy it easily within a day. Here is the github link:
https://github.com/AstralForest/Power_BI_Monitoring

The architecture looks like this:

and the example report like this one:

[johnpjustus]

Hi - Thanks for the solution. This looks great. We have ADF and Azure Databricks workspace.

Would it be possible to outline the instructions to help configure?

Thanks,

John

[Miszel8]

Thanks @johnpjustus ,

Concerning the version which is available on GitHub:

• I've a video with the configuration on my to do list 🙂
• You can check the deployment guide here: https://github.com/AstralForest/Power_BI_Monitoring/blob/master/deployment.md
• or you can drop me a message

Concerning Databricks:

• After some adjustments you can use DBR instead of SQL DB if you want
• I'm working on the version without Azure Functions (ADF + SQL DB) , as it does not use Azure Functions it can be potentially easier to migrate to DBR
• If you have all your ETL/Data on Databricks it maybe good idea to put there also this solution, on the other hand the solution itself is pretty independent from the standard ETL/Reporting and the costs of the infra are not high

[johnpjustus]

Thank you so much, I will give it a try to deploy!!