topic Re: Import data from SharePoint URL Link in Report Server

Import data from SharePoint URL Link

Shanna_1018 — Fri, 04 Feb 2022 15:35:15 GMT

Hello, i need to import a few URL links from SharePoint into Power BI, but i've justs learned, that Power BI is only able to import the tribe link/the "main link" (under the field "Home" or under "Start"), like in the video mentionned here: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

However, i do not need the data from the "Start" or "Home", but i need to import the data which i can find by clicking the button with the special information i need. When i import the data from the main/trible link (under "Start"), i cannot find the needed information.

Please, could you help me to solve the problem?

Thank you,

Best regards!

Re: Import data from SharePoint URL Link

lbendlin — Sun, 06 Feb 2022 01:44:05 GMT

Careful, there is a difference between a Sharepoint Document Library (where you find the files) and a Sharepoint List (which behaves like a database table). You may have used the wrong connector?

Re: Import data from SharePoint URL Link

Shanna_1018 — Wed, 09 Feb 2022 13:34:40 GMT

It may be possible. Anyway i go to the Start and import the link, but i can only see the HTML Code of the file. Somehow i could get the data (taken from from the URL of the field "Start") in the needed format, but it was the wrong one (the information i do not need). And when i take the link directly from the field i need informations from (Repair/Field service) , there is a message which pops up and indicate an authentification problem... which is strange. Could you help me, please?

Thank you,
Regards!