Reading a onedrive excel file

[Economech]

It seems like Power Bi does not have OneDrive in the list of get data which sounds weird. I have got an excel file in my one drive accessible with a unique and global address (URL). How I should set it up in Power Bi to read the data from this excel file and import it?

[v-yangliu-msft · Accepted solution]

Hi  @Economech ,

Here are the steps you can follow：

1. Open OneDrive, find the required Excel file, and choose to open it in the APP.

2. Select the file in Excel, select info, select link, and click copy link to clipboard.

3. Open Get Data in Desktop and select Web.

 4. Remove the ?web=1 string at the end of the link so that Power BI Desktop can properly navigate to your file.

5. If Power BI Desktop prompts you for credentials.
For on-premises SharePoint sites, select Windows, for or Microsoft 365 or OneDrive for Business sites, select Organizational AccountSelect the content to be imported and confirm it is complete.

 6. Select the content to be imported and confirm it is complete

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandukrishnavs]

@Economech 

Open your OneDrive folder using the browser. Then locate your excel file.

Select your file and click 3 dots near that file. Then click details.

Right side, you will get a small box. Scroll down and copy the path. (Click on copy icon near text: Path)

Now you can open the Power BI desktop and use the web connector. 

You can choose the authentication type as an Organizational Account.

[Economech]

Unfortunately, none of these could solve my problem. Please let me know if you can open this link and read the rows and column on Power Bi:

https://economech-my.sharepoint.com/:x:/g/personal/analytics_economech_onmicrosoft_com/EQiJeGV3XsZDv...