Automate updating Power Bi usage logs for a dashboard available in Power Bi Service

Power BI Online Service
1

We currently export the Power BI Audit logs to a master csv file and append it every 2 months with new data to refresh the dashboard available on Power Bi Service.

How can we automate updating the power bi logs instead of having to manually update the file every 2 to 3 months.

2

Hi @alang,

Using DataMentor/EDNA AI tools built within the EDNA platform. This what comes up.

To automate updating the Power BI Audit logs, you can follow these steps:

1. Automate Data Export

  • Power Automate: Use Microsoft Power Automate to schedule the export of Power BI Audit logs automatically.
    • Create a flow that uses the “Export to CSV” action.
    • Set a trigger to run every 2 months.

2. Use Azure Data Factory

  • Data Pipeline: Use Azure Data Factory to create a data pipeline that pulls the data from Power BI Audit logs.
    • Schedule the pipeline to update at your desired interval.

3. Store Data in Azure Blob Storage

  • Save the exported CSV files in Azure Blob Storage to facilitate smooth access for Power BI.

4. Use Power BI Dataflows

  • Dataflows: Create a dataflow in Power BI to connect to your blob storage or the automated output location.
    • This will ensure the data is continuously refreshed in Power BI Service.

5. Schedule Refresh in Power BI

  • In Power BI Service, configure dataset settings to refresh automatically based on the dataflow schedule.

Example Workflow:

  1. Power Automate exports logs and saves them to Azure Blob Storage.
  2. Azure Data Factory checks for new files and pulls them into your data storage.
  3. Power BI Dataflow connects to Azure Blob Storage to fetch the latest logs.
  4. Power BI dataset refreshes based on the dataflow.

Benefits

  • Reduces manual effort.
  • Ensures up-to-date data in your dashboards.
  • Allows for more frequent updates without increased workload.

Implementing the above steps should streamline your process and maintain the integrity of your reporting.

Please give DataMentor a try!!!

I hope this helps.
Keith

1 Like
3

Thank you @Keith I appreciate the options. I will take a look at the options provided above and get back to you

1 Like
4

Hi @Keith what are the specific steps to creating an export to csv flow using power automate. Do we need to define the parameters or can we initiate with the existing csv file and have the logs write to the csv file incrementally?

5

HI @alang

Please use DataMentor to help you on that.

Ask the question in Project “Solution” and following the drop down to help you with the process for a solution to your issue.

Thanks
Keith