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

     

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
5 years ago

cwilliams2109 

In the power Query Editor as shown in picture, let the users change the user name 

C:\Users\christopher.williams\COMPANYNAME\Finance - Contract Support\CST\Power BI\BI Reports to the user name. Then they will be ablve to access the data .  The path is dependant upon user profile

 

'