Getting OneDrive Files into Power BI Desktop

Getting OneDrive Files into Power BI Desktop

The other week I was working with a client whose data was stored somewhere in their OneDrive. No Problem, right?

Sort of.

We uploaded a very simple calendar table to OneDrive and tried tied to import it to Power BI. We navigated to the file and copied the URL.

It looked something like this:

https://Oan4-my.sharepoint.com/personal/UserName_CompanyName/_layouts/15/WopiFrame.aspx?sourcedoc={1EC4284D-0837-46B2-AC51-813FC187934C}&file=Dynamic%20Calendar%20Table%20Template.xlsx&action=default

Then we went to Get Data: From Web, and pasted in the link:

So far so good? Not quite. We got this annoying error message:

Huh?

If you did this, you followed the right steps, but you copied the wrong link. Here’s where to find the right link:

  1. Find the file in your OneDrive
  2. Click on ‘…’ and Select ‘Details’

Something should appear on the right side of the browser window. That link highlighted there? That’s what you want.

  1. Copy this link

  1. Modify the link.

The link will look something like this:

https://Oan4-my.sharepoint.com/personal/UserName_CompanyDomain/Documents/CRM Dashboard Source Files/Calendar Table/Dynamic Calendar Table Template.xlsx?d=w1ec4284d083746b2ac51813fc187934c

Sometimes the link has some ‘stuff’ at the end, and sometimes it doesn’t. I don’t know why.

Basically, you need everything up to the file extension. So in this case, we need to delete everything that is bold. The modified link should look like this:

https://Oan4-my.sharepoint.com/personal/UserName_CompanyDomain/Documents/CRM Dashboard Source Files/Calendar Table/Dynamic Calendar Table Template.xlsx

  1. NOW go to Get Data: From Web and Paste the link into the field.

And there you go. Your Data is imported 🙂

Al.