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.
Hi Noob,
I would recommend that you store that excel file in sharepoint and connect your power bi to that excel in sharepoint. This way you can set the schedule refresh to pull new data from that excel file, instead of your machine.
Check this: https://www.youtube.com/watch?v=YI6ey8EvIAI
Hello,
Thank you for your reply. The excel file is posted on my OneDrive business and also on the PowerBI server (same place as the dataset and pbi report). I can personally go to the PBI site and take care of it myself, i dont understand why my co-worker is seeing an issue, which is looking for my personal PC to be on since all files are online. I dont understand why the file is looking for my pc being online since the "source" file has always been on OneDrive and now it is on the server page. Any thoughts?
Do you sync your Onedrive to your computer? I have experienced business users connecting to onedrive file through the local drive because the onedrive is synced to the local drive.
One way to check is to open up your report in power bi desktop and click Data Source settings:
If you connect to Onedrivem you should see an url. If you see your local rootfolder, it means that you are connecting to the excel file through your local drive.Is this the case? if yes, then it is an easy fix.
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.