Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I am trying to develop a report in which I get data from an excel file in a sharepoint folder.
My manager shared this folder with me so I copied the path of an excel report in this sharepoint folder and uploaded in PowerBI. My manager replaces this report everyday for another with exactly the same name.
In the first day it was perfect when I connected but after my manager replaces the report for a new one (he replaces the file daily but keep the same name) I cannot access anymore and I get the below error. From this I understand that when he replaces the excel file in sharepoint folder I cannot access the query anymore? How can I solve it and have the info automatically updated whenever he replaces the file on sharepoint?
Thank you in advance!
Solved! Go to Solution.
Hi @Anonymous ,
You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint, click "Edit permissions", then click "Edit", choose organizational account method (or Microsoft account) to sign in the appropriate credential.
or click "clear permissions" for stored SharePoint data source, then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method. See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.
https://xxxxx.sharepoint.com/sites/<sitename>
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be a Super User!
Hi @Anonymous ,
You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint, click "Edit permissions", then click "Edit", choose organizational account method (or Microsoft account) to sign in the appropriate credential.
or click "clear permissions" for stored SharePoint data source, then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method. See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.
https://xxxxx.sharepoint.com/sites/<sitename>
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , refer
https://rukiatu.com/access-to-resource-is-forbidden/
https://community.powerbi.com/t5/Desktop/Get-Data-sharepoint-folder-issue/td-p/586727
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |