Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Vidhya Ranganathan]

Hi , 

 

I encountered problem while trying to get data from a excel file in  onedrive for which I have permission to view and edit.

Whereas the owner who uploaded the file was able to connect to power BI Desktop Using the same steps below, and was also able to connect the excel file to PowerBI template file with no error.

 

StepS Followed:

1.Get Data ->Web 

URL: 

https://*******my.sharepoint.com/personal/**********_onmicrosoft_com/Documents/Document/Uni/Master%20Excel.xlsx

 

Error:

Unable To Connect 

We encountered an error while trying to connect

 

Details: “SharePoint: Request failed: https://********my.sharepoint.com/personal/**********_onmicrosoft_com/Documents/Document/Uni/Master Excel_xlsx/_api/contextinfo”

 

Any Help Appreciated,Kindly suggest your thoughts on this.

 

Many Thanks,

V

——————————
Vidhya Ranganathan
Senior Business Intelligence Analyst
——————————

[Vali Abdykarim]

@Vidhya

Hi,

Can you please tell me how are you getting that link???

• I assume you getting it by clicking share file in OneDrive

The following will not work you have to open that file in Excel and copy the link from excel see steps below:

1. 
2. 
3. 

This should work for you!

——————————
Regards

Vali
——————————
——————————————-