Update data from PBI online

Hi

You can have an excel file in a sharepoint folder, then sinc that sharepoint folder in your pc so that the file is available localy in your machine.

Then if you edit the file you will only need to refresh the dataset in the power BI service. Also you can configure automatic refresh so you dont have to worry about it.

I guess this video could help you understand

https://www.youtube.com/watch?v=YI6ey8EvIAI&ab_channel=LernenTech

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Hi Anonymous ,

Besides that the method as suggested by Anonymous put the local file in Sharepoint, you can also refer the following links to install the gateway first and configure schedule refresh to get the update of the local file. The on-premises data gateway acts as a bridge. It provides quick and secure data transfer between on-premises data, which is data that isn't in the cloud, and several Microsoft cloud services.

Schedule Refresh Local Files on Power BI Web Site 

Configure scheduled refresh

Best Regards