cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft
Microsoft

Excel Document from Sharepoint - Access Denied

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

https://community.powerbi.com/t5/Integrations-with-Files-and/Import-Data-from-an-Excel-sheet-in-Shar...

https://community.powerbi.com/t5/Desktop/Import-Data-from-Excel-sheet-in-SharePoint/m-p/454012#M2103...

https://community.powerbi.com/t5/Desktop/Cannot-link-a-Sharepoint-Excel-file-to-Desktop-PowerBI/m-p/...

 

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?

1 ACCEPTED SOLUTION
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

You're fantastic!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors