cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AlejandroPNW Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Community Support Team
Community Support Team

Re: Excel Document from Sharepoint - Access Denied

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.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Excel Document from Sharepoint - Access Denied

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.
AlejandroPNW Frequent Visitor
Frequent Visitor

Re: Excel Document from Sharepoint - Access Denied

You're fantastic!