Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get a SharePoint file path to use in PBI without the Desktop app

To connect to an Excel file stored in SharePoint Online (or OneDrive), the typical instructions are to: Go to SharePoint (or OneDrive) and open the file in the DESKTOP app Click File, then Info c...
Need Help
Tips and Tricks
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Do like this (I am giving this step from personal Onedrive, hence should work for Sharepoint online)

Right click on your file - Embed

I got below code

<iframe src="https://onedrive.live.com/embed?cid=E11B26EEAACB7947&resid=E11B26EEAACB7947%217398&authkey=AA8hHIRW2IjGghI&em=2" width="402" height="346" frameborder="0" scrolling="no"></iframe>

Now copy the bold portion starting from resid till just before &em

Now, below is sample link where bold portion should be replaced with above copy.

https://onedrive.live.com/download?resid=AAXXXX&authkey=AAXXXXXXX&em=x&app=Excel

Hence, this would become

https://onedrive.live.com/download?resid=E11B26EEAACB7947%217398&authkey=AA8hHIRW2IjGghI&em=x&app=Excel

This link you can feed into Web connector of Power BI.