CODEWITHSUNDEEP
sharepointpowerbipowerbi-desktoppowerbi-datasource
Priyanka2304
Priyanka2304

Reputation: 210

Connecting Power BI to SharePoint

I am trying to connect Power BI to SharePoint to source my data and create a report. I see 3 SharePoint options under Get Data in Power BI. I am not very sure which one to use. I tried all 3 (SharePoint folder, SharePoint Online list and SharePoint list) but I end up with an error mentioned below:

enter image description here

The url I am using looks like: enter image description here

Any help is appreciated.

Upvotes: 0

Views: 873

Answers (1)

Angelo Canepa
Angelo Canepa

Reputation: 1781

You should use Sharepoint Online List.

This would prompt a message that would ask for your site, where the list is stored

enter image description here

The site URL structure should look like this

https://organization name.sharepoint.com/sites/site name/

After that, it would ask for your login details and finally a navigation pane with all the assets of that site including your list. In my case, Test 2 is the list.

enter image description here

Upvotes: 1

Related Questions