sharepoint folder issue 404 Not found

[twister8889]

Hi guys,

I am trying to connect to the Sharepoint folder, but I have the message:

We encountered an error while trying to connect.
Details: "Web contents failed to get contents from: "https//mysite/teams/page/_api/web/lists/getbyid('charecteres')/RenderListDataAsStream'(404): Not found"

How can to solve this?

- I can connect to the Sharepoint Lists
- I can connect to one specific excel into SharePoint by Web connection

[amitchandak]

@twister8889 , have correct the url while taking from SharePoint

example : https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

[twister8889]

First, of all, thank you for your answer...

I can connect by WEB option, but I need to connect with a lot of excels file, in this option, I connect by one excel file. I would like to connect the document library in SharePoint and read all files to combine in power bi.

[v-jingzhang]

Hi @twister8889 , it seems the URL is probably not correct. You may try entering the root URL for the sharepoint site. Please check if these links are helpful.

https://blog.pragmaticworks.com/quick-tip-connecting-to-a-sharepoint-folder-in-power-bi

https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/c...

https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.