Forum Discussion

albatoul's avatar
albatoul
Icon for Helper I rankHelper I
4 years ago

Excel sheet with Power bi

Dear all please I need your help before the next 24 hour 💔  I connect my excel sheet with power bi and finish my work  then to find out that when I share it with other users it's dose not refresh...
albatoul's avatar
albatoul
Icon for Helper I rankHelper I
4 years ago

thank you for your fast replaying I put it in OneDrive in my PC do you thing is google drive is better ? 

and is it possible for youser to update the sheet when it's in google drive ?

askhanduja's avatar
askhanduja
Icon for Helper I rankHelper I
4 years ago

Try opening the onedrive location in you browser and copy the address from there. It should look something like https://<your-org-name>.sharepoint.com/<your-workspace-name>

 

It is this location that you need to supply to the power query editor as the source location for your excel file.