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.
I've tested this process in the past and it worked fine. However, recently I've been getting this error returned and I can't pinpoint the reason.
I have a CSV file saved in my files location for Onedrive for Business
I open it in the Excel app and click "Copy Path"
In Power BI I use the "Web" connector and remove the "?web=1" from the string:
At this point I would expect to get an authentication screen screen similar to this:
but instead I get this - every time.
Any ideas why this error shows up instead of the 'authentication prompt'?
Solved! Go to Solution.
Solved
The issue was related to global permissions in the Power BI Desktop file.
In my case - I had previously tried to connect to a file in my OneDrive folder for Buisness - Shared with me.
This saved a connection to this file - which generated the error.
Prior to this I had also connected to files on my OneDrive for Business - so I also had another global persmission for this "Onedrive" connection path.
By clearing permissions on both connection routes: I was able to request that the authentication screen be populated when I tried to connect.
It appears that the previous connection stored in Global Permissions (which generated that error) was being used. Extraction - the issue has been fixed.
Solved
The issue was related to global permissions in the Power BI Desktop file.
In my case - I had previously tried to connect to a file in my OneDrive folder for Buisness - Shared with me.
This saved a connection to this file - which generated the error.
Prior to this I had also connected to files on my OneDrive for Business - so I also had another global persmission for this "Onedrive" connection path.
By clearing permissions on both connection routes: I was able to request that the authentication screen be populated when I tried to connect.
It appears that the previous connection stored in Global Permissions (which generated that error) was being used. Extraction - the issue has been fixed.
@swise001 , refer to the similar issues solutions.
https://rukiatu.com/access-to-resource-is-forbidden/
https://community.powerbi.com/t5/Desktop/Get-Data-sharepoint-folder-issue/td-p/586727
https://community.powerbi.com/t5/Desktop/Expression-Error-Access-to-the-resource-is-forbidden-sharep...
https://community.powerbi.com/t5/Desktop/Access-to-the-resource-is-forbidden/m-p/366485
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |