![]() If you copy the share link for the file, that’s got to work, right? Nope! ![]() ![]() It will appear to be connecting, and then… ha, ha, fooled you! You’ll get the error message below. Initially, it will ask you to sign in to your Microsoft account. If you open the file online and look at the URL in the address bar, that’s got to be it, right… wrong! This won’t work. The problem is that it’s harder to find the URL than you might think. OneDrive and SharePoint both use web connections, so the first thing we need to do is find the URL of the file. So, in this post, I want to show you how to connect to OneDrive or SharePoint with Power Query. If you are looking to get data from OneDrive personal, check out this post: Get data from OneDrive Personal files with Power Query Actually, sometimes what seems like the answer can lead us down the wrong “file” path (oh, sorry, that was a terrible Dad joke).Īs more companies use online storage locations such as OneDrive and SharePoint, the more relevant the data connectors to these sources become. Done! However, what if we want Power Query to get data from OneDrive or SharePoint? How do we do that? It’s not obvious. We just need to navigate to the location… Bam. In Power Query, when we connect to a local file, it’s reasonably obvious how we do that it’s built directly into the UI.
0 Comments
Leave a Reply. |