Ask a new question

How can I create a live connection between my Power BI report and an excel document so that the report updates itself when I update the excel spreadsheet?

I am new to the Power BI platform and I just want to know how I can create a connection between my excel document and the Power BI report so that it automatically updates when I make changes to the excel document?

Dear respected LLAYTON TITUS,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, if your Excel file is stored on OneDrive for business, you can use the Web data source in Power BI to connect. This way, you can set up a scheduled refresh for your Power BI report and it will automatically update when you make changes to the Excel file.

For your reference article:

Connect Excel to Power BI datasets - Power BI | Microsoft Learn

Create Excel workbooks with refreshable Power BI data

Appreciate your patience and understanding and thank you for your time and cooperation.

 

Sincerely,

Waqas Muhammad

• Beware of Scammers posting fake Support Numbers here.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 19, 2024 Views 503 Applies to: