Forum Discussion
Connecting to a SharePoint List Office 365 error
Hi John
When trying to connect to the list are you using the full URL of the list, or just linking to the site URL?
i had a similar problem which was caused by trying to link to the full list address.
See thread:
Advocate IHi all!!
I found the solution!!!!!!💪
You just need to copy the URL until your principal Folder tree ( for example: sharepoint/sites/demo)
Once you are connected you hace to clock on transform data, and you will see all the documents you have on your sharepoint.
Then you have to filter by the document you want to change and after that you have to click on binary on the content column.
After that you need to click on Table to import the data in to Power BI.
There you have a video to explain it propertly :
Advocate IIHi, cgil .
Thanks for sharing.
I try to use the solution and the connection works fine, but I have a complex directory structure, with hundreds of files. To connect to an specific Excel file I need to select it in a long list.
I have to change the source file monthly, and the challenge is big.
Isn't any way to point to an specific directory? We always need to point to the root directory?
Best regards,
Emanuel
- cgil
At the moment I can't find any other way to point to an specific directory...