Power BI

Completed

SharePoint/Office 365 List Data Source

Vote (664)

Rui Quintino on 21 Nov 2014 07:39:23

using SharePoint lists, alternatively odata feeds

Comments (51)

Comments (51)

Amit on 05 Jul 2020 22:01:56

RE: SharePoint/Office 365 List Data Source

https://app.powerbi.com does not show me sharepoint list options but it shows in powerbi designer tool

Diego on 05 Jul 2020 22:00:53

RE: SharePoint/Office 365 List Data Source

We need a schedule refresh data from sharepoint list in power bi site please

Amit on 05 Jul 2020 22:00:20

RE: SharePoint/Office 365 List Data Source

can it connect easily to on premise sharepoint 2013 lists, we have many clients with on premise

Andreas Munch, Skill AS on 05 Jul 2020 21:59:40

RE: SharePoint/Office 365 List Data Source

There is a simular request regarding non-english sharepoint list. http://support.powerbi.com/forums/265200-power-bi/suggestions/7318742-sharepoint-list-for-non-us-countries

Adi Mader on 05 Jul 2020 21:59:01

RE: SharePoint/Office 365 List Data Source

gentlemen.... yes, it is supported in PowerQuery and PowerBI Designer... but only... if the Sharepoint-Site is in english...
Microsoft never resolved this problem for years... and I think there is an international market out there with different language settings

Miguel Llopis on 05 Jul 2020 21:58:04

RE: SharePoint/Office 365 List Data Source

This is supported in Power Query and the Power BI Designer. You could already connect to these sources, build your reports and upload them / schedule refresh in the Power BI service for them.

Thanks,
M.

o365SPO on 05 Jul 2020 21:57:38

RE: SharePoint/Office 365 List Data Source

'+1 on SPO List Source for Power Bi

Ned Scheetz on 05 Jul 2020 21:57:27

RE: SharePoint/Office 365 List Data Source

If Office 365 is really trying to capture SMB's, Power BI with List data would be an obvious add. Kind of absurd that the built in Office 365 data structure doesn't merit inclusion in the primary data analysis tool. I know lists are limited, but it's acore feature of Office 365 and most O365 users have a ton of data there.

Silviu Popa on 05 Jul 2020 21:57:23

RE: SharePoint/Office 365 List Data Source

this is the same as : vote there

http://support.powerbi.com/forums/265200-power-bi/suggestions/6748539-sharepoint-office-365-list-data-source

Joseph Curet on 05 Jul 2020 21:57:15

RE: SharePoint/Office 365 List Data Source

SharePoint Lists are critical for my organization, we store most of our operational data in Lists. Thanks!