cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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!

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 293 members 3,368 guests
Please welcome our newest community members: