Forum Discussion
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 try to connect PBI desktop to it, I go to New Data Source -> Web. I insert the link but it doesn't recognize my credentials. It clearly states "you are already signed in" but right above it it says the current user isn't signed in? I don't understand why.
I've tried applying the settings to the folder and the file and still nothing.
What is the problem?
Try using the clean sharepoint site URL without all the /:x:/p/ stuff. Clear out all permissions from the connection in Powr BI Desktop.
4 Replies
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.Try using the clean sharepoint site URL without all the /:x:/p/ stuff. Clear out all permissions from the connection in Powr BI Desktop.
