Forum Discussion
Connecting Excel in SharePoint to Power BI
Hi Anonymous ,
When you are connecting to Sharepoint, the connection string is the sharepoint HOME link (not the final one - the file destination). Having said that, go to your sharepoint site and navigate to its homepage and copy that link, which should look something like:
Use this in the connection string and within PBI navigate to the desired file (this will give the full content of the SP site so you may need to filter to find your file):
Finally, when you find your file, open the "Binary" column and it will open the file.
Extra: you can delete any filtering steps added to the query as they are irrelevant to PQ itself.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Helper VAnonymous This is going to be rough to explain because I cannot show you our SharePoints.
But you select under the "More option" and select SharePoint. But the problem is that you cannot target specific folders immediately, so you must connect to all of them.
Make sure the Link is basically the homepage. You may have to try a few options to get it to work.
Then, once you get connected, you will see ALL OF THE files in sharepoint. Make sure you filter them with the little action dropdown and then you can load and transform from there.
- chonchar