Forum Discussion
Connecting to OneDrive excel file
Hi Pragati11 yes onedrive and power bi use the same account.
Yes if I go to onedrive I can see the file. If I enter the file url into the browser the excel file opens.
Hi Anonymous ,
Create a new Web source in Power BI using the steps defined in the following blog:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Check if you are able to connect or not. I am able to connect using the steps as mentioned in the above link.
Make sure to add a new data source and test it.
Thanks,
Pragati
Thanks Pragati11 but I'm still getting the same error when I click on OK on the step below (with my url of course). It's not prompting me for credentials.
Hi Anonymous ,
Have you removed te highlighted part from the copied URL?
Can you please open a new fresh Power BI Desktop file and try because as I don't have access to your power bi file, I am not sure where things are going wrong as this is a straight forward way to connect to one drive.
Clear Power Bi cache before doing this.
Thanks,
Pragati
Hi Pragati11 , yes the highlighted part was removed from the copied URL. I've tried from a new power bi file after clearing the cache but it still fails with the same error message unfortunately.
This was very helpful for me - solved the problem. Thanks!
