Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cannot get connected to excel via Web

I keep getting denied when trying to connect to an excel file on my onedrive. I feel like I've tried everything already and still cannot figure it out.  The file is stored on my onedrive so when I tr...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Try using the clean sharepoint site URL without all the /:x:/p/ stuff. Clear out all permissions from the connection in Powr BI Desktop.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

 

It seems you are not using the correct link for the Excel file. Please open the Excel file in Excel app and go to Info to get the link. And remove the ?web=1 string at the end of the link.

  • Correct link format: 

https://xxxx-my.sharepoint.com/personal/xxxxxx/Documents/xxxx/Data_online.xlsx

 

  • Wrong link format: 

https://xxxx-my.sharepoint.com/:x:/g/personal/xxxxxx/EaTgxxxxxxxxxxSZ0R9-4w?e=jjGX33

 

Reference:

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

 

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

thank you, clearing out permissions as per the the other comment resolved the issue. Any idea why that could have been the problem?