Power BI Usage Data

[algunn14]

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!

[lbendlin · Accepted solution]

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.

[algunn14]

Thanks @lbendlin , when you say access directly, what specifically do you mean? Where would you recommend we store the data?

[lbendlin]

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.