Forum Discussion

cwilliams2109's avatar
cwilliams2109
Frequent Visitor
5 years ago
Solved

Using excel data source across one drive

Hi   Our company utilises one drive. I have produced a power bi report that I want various staff to be able to use, refresh etc... The data source is simply an excel file on the one drive.. Howeve...
Need Help
  • cwilliams2109's avatar
    cwilliams2109
    5 years ago

    Hi

     

    Thanks for all the help on this.. I have found another method of using web.contents and the URL path to the excel file. This seems to have worked.

     

    Thanks

    Chris

     

negi007's avatar
negi007
Community Champion
5 years ago

cwilliams2109 

I hope you are able to connect to the data from one drive and are able to publish it to powerbi services. In powerbi services, you can also schedule refresh from your one drive data. This way data will get refreshed automatically using your credentials. 

refer to below links and write back if still need help.

 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive#:~:text=Power%20BI%20can%20then%20synchronize,your%20file%20again%20from%20OneDrive.

 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive