Forum Discussion
Changing Source from OneDrive to Sharepoint
Hello,
I just realized that all this time my PBI was linking to my onedrive account even though the files are on sharepoint. I have gone through each of my queries and changed the source with the sharepoint link. Each query is showing no syntax errors. However, when I click "close and apply" I get tons of errors and I'm not sure where to even begin. Any thoughts?
3 Replies
There is a problem on "THP Item Mapping" table, I suspect that there are unnecessary rows on that excel table
Hi, trishd1223
Thanks for the reply from AngeloParana .
Make sure you have the required permissions to access your SharePoint files. Unlike OneDrive, SharePoint often has more complex permission settings that may restrict access to certain files or folders. Verify that your account has the required level of access.
Also double-check the SharePoint link used as the new source. SharePoint URLs can be lengthy and complex, and a small mistake in the URL can lead to an error. Make sure the link points directly to the file and not to a regular page or folder. After you change the feed, Power BI might ask you to re-enter your credentials for the new SharePoint source.
If a specific refresh error is mentioned, see the Power BI documentation on troubleshooting tile refresh errors for guidance on common issues and their solutions:
Troubleshooting tile errors - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It looks like you are using the folder connector - when you change sources with that connector, one of the child items in the folder of parameters and whatnot that it creates also has to be updated, so you need to update it two places per folder query. I would click through each of the items in the folder and make sure it's updated for any that reference it.
