How to properly connect an excel file that is located on One drive to PowerBi report?

[zenonsbelskiss]

Hello, PowerBi Pros.

I have a ready PowerBi Desktop file that I have made on my computer using an excel sheet that is located on my computer too. Then I published the PowerBi Desktop file to the online service and created the link, using which every one can access the report.

Now I have to make that same report take informaion from a similar file (just an updated one) that has to be located somewhere on the internet, probably OneDrive. Is it possible that the online report refreshes itself automatically, taking the information from somewhere in the cloud?

Thanks in advance, I am having big time trouble trying to do this, so a detailed tutorial would be greatly appreciated.

Zenons Belskis

[v-lili6-msft]

hi @zenonsbelskiss 

you could refer this document:

Use OneDrive for Business links in Power BI Desktop

and then set schedule refresh in power bi service.

Regards,

Lin

[amitchandak · Accepted solution]

@zenonsbelskiss , I think file on one drive you should be able to refresh using power Bi service.

I tried these steps to configure : https://5minutebi.com/2018/04/09/power-bi-using-and-refreshing-excel-datasources-with-onedrive/