Updating Power BI dashboard daily

[DataNinja777]

Hello Power BI community,

I'd like to update various Power BI dashboards on a daily basis by downloading the data from SAP and saving the raw data in a particular Excel file and refreshing Power BI reports.  Although it only takes a few minutes to do each task, there are many reports and I'd greatly appreciate it if you could let me know how I can automatically update the reports once a day without any involvement.  I am thinking Power automate may be a solution, but I haven't got any experience in this area. Please let me know.  

[anupamj]

Hi @DataNinja777 ,

Have you already used the PowerBI scheduled refresh? Guide is here: https://youtu.be/TA0-tya44K0

Microsoft recommended architecture for PowerBI / Fabric integration with SAP (See the cached method): 

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/integrate-microsoft-fabric-with-sap-d...

Questions? please reach out.

Anupam

[Anonymous · Accepted solution]

Hi @DataNinja777 ,

Thank you for reaching out for assistance with automating the daily update of your Power BI dashboards. You are on the right track considering Power Automate as a solution for your needs. Power Automate can help you automate the process of downloading data from SAP, saving it to an Excel file, and refreshing your Power BI reports.

There is a simple sample about how to use Power Automate.

Refresh Power BI Dataset by Integrating Power Automate in the Report (mssqltips.com)

Get started with Power Automate - Power Automate | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.