Forum Discussion
PBI Usage Logs
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
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:
5 Replies
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:
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
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
This is great, but I'm still surprised there is no OOTB solution from Microsoft on this topic.
