cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Connecting to a shared excel file in onedrive for business To PowerBI Desktop

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

2 REPLIES 2
New Member

I am facing same issue. Have you been able to resolve this?

Microsoft
Microsoft

@Vidhyashakthi12,

 

Does this excel file stored on Onedrive for business or SharePoint site?  From your URL and error message, it seems that you get data from sharepoint site. Please ensure that you have corresponding permission to this excel file. Please refer to the link below to see the details.
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

 

Regards,

Charlie Liao

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors