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.
All, another in the saga of excel from sharepoint. I'm attempting to pull data from an excel sheet in a sharepoint folder, but I'm being met with an "Access Denied" window.
I've attempted, as best I can to follow the directions here:
https://community.powerbi.com/t5/Desktop/Import-Data-from-an-Excel-sheet-in-SharePoint/td-p/47223
Including the method where you pull the excel down in desktop and fine the url via the doc info.
I'm at a total loss.
Any ideas?
Solved! Go to Solution.
Hi @AlejandroPNW,
Please check if you have installed the latest version of Power BI Desktop ( 2.66.5376.1681).
If not, please update it and test again. By my test with this new version, everything works as expected.
If it still have problem , please create a new pbix file and clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the sharepoint source >> Clear Permissions.
Then you could get data again.
Best Regards,
Cherry
Hi @AlejandroPNW,
Please check if you have installed the latest version of Power BI Desktop ( 2.66.5376.1681).
If not, please update it and test again. By my test with this new version, everything works as expected.
If it still have problem , please create a new pbix file and clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the sharepoint source >> Clear Permissions.
Then you could get data again.
Best Regards,
Cherry
You're fantastic!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |