Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 be...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    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

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You're fantastic!