Forum Discussion
Power BI Audit Logs - Azure Automation Solution
Hi, My organisation desperately needs some oversight of power bi usage metrics - I've managed to get a PowerShell script working with task scheduler to export the daily usage into csv as per the s...
Yes, pretty much. Or if you don't care about history you can do the API calls directly in the Dataflow PowerQuery (rather than with Powershell)
Since these are csv files it is more appropriate to push them into Dataflows. Putting them into a database is just adding more complexity.
So do you mean storing the CSVs on a shared drive somewhere and connecting to this drive via dataflow?
Yes, pretty much. Or if you don't care about history you can do the API calls directly in the Dataflow PowerQuery (rather than with Powershell)