Forum Discussion
Report Refresh
Good! We may have a solution. We need to get the url through the excel, not the online address.
1- Open the excel file on your computer
2- Go to File > Info > Copy Path
3- Go back to your power bi desktop > Data source settings > Change Source
4- Paste the path and remove "?web=1" at the end of the url
5- click ok, refresh the report and check if it load succesfully.
If it doesnt load succesfully, it means that there are other dependent transformation steps in Power Query that you need to modify.
You are right, it shows my pc there, i am going to try to change somehow to an online address. perhaps i will go to the onedrive site and copy the web address and change the source, would it mess up my report?
Good! We may have a solution. We need to get the url through the excel, not the online address.
1- Open the excel file on your computer
2- Go to File > Info > Copy Path
3- Go back to your power bi desktop > Data source settings > Change Source
4- Paste the path and remove "?web=1" at the end of the url
5- click ok, refresh the report and check if it load succesfully.
If it doesnt load succesfully, it means that there are other dependent transformation steps in Power Query that you need to modify.
I did that and it did update! i will run a test and ask my co-worker to refresh while my pc is off and will let you know.
Thank you so much for your help!!!!
Perfect! If you could mark this as solved, that would be great! You can always continue with the thread if there are follow up questions.
Also set schedule refresh, so your user dont need to refresh it ( that requires taking over your dataset)
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh