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)

Robert Barbrow on 05 Jul 2020 22:08:53

RE: SharePoint/Office 365 List Data Source

'@Miguel when trying to connect to office 365 Sharepoint Online you will get the following error DataSource.Error: We couldn't parse OData response result. Error: A null value was found for the property named 'Set_x002d_aside_x0020_Type', which has the expected type 'Collection(Edm.String)[Nullable=False]'. The expected type 'Collection(Edm.String)[Nullable=False]' does not allow null values.
Details:
DataSourceKind=SharePoint
DataSourcePath=https://markon365.sharepoint.com/OPS/_api/Web/Lists(guid'f1ba3235-9f27-4ce6-ace2-6f28923453026')/Items

you must change the api version from 15 to 14 to connect

skeeypete on 05 Jul 2020 22:08:37

RE: SharePoint/Office 365 List Data Source

As Trump would say... this would be huuuuuuuuge. Collaborating on SharePoint Team Sites that automatically update PowerBi connections is essential!

Koos on 05 Jul 2020 22:08:35

RE: SharePoint/Office 365 List Data Source

Please, make this happen Msft. You are on the right track the way products get integrated, however this a huge miss.

Power BI User on 05 Jul 2020 22:08:24

RE: SharePoint/Office 365 List Data Source

What's the point if I cannot connect to SP lists online.

Power BI User on 05 Jul 2020 22:08:16

RE: SharePoint/Office 365 List Data Source

I was told not to store company data in oneDrive or oneDrive for business. I had to move everything to sites. Now you tell me that I have to move it all back to oneDrive? Make up your minds.