Forum Discussion
Power BI Usage Data
I have written a powershell script to pull usage data like report views etc. For next steps, I was planning on finding a way to run this script daily and store it in a database, then create a Power BI report to show us which reports haven't been viewed in the last X months etc.
A coworker of mine believes that I can use Azure Log Analytics to serve this need instead? I don't have any experience with Log Analytics and wanted to first pose the question if this is indeed possible with Log Analytics before I spend a bunch of time redoing my solution.
Is this possible? Any help is greatly appreciated!
Possible? Yes.
Free? No.
Keep running your script. No need to store the results in a database. Store them as JSON or Parquet and access directly.
3 Replies
Possible? Yes.
Free? No.
Keep running your script. No need to store the results in a database. Store them as JSON or Parquet and access directly.
Whatever file storage you are comfortable with . A SharePoint Document Library can do in a pinch (given enough quota).
"access directly" means ingest them as is directly from Power BI. If you want, load them into a dataflow or datamart etc.
