Power BI with Sharepoint issues

Hello,

I need to get some list data from Sharepoint online for a report.

So far I'm having the following issues:

Using the sharepoint online list datasource, when the list is empty I receive an empty table from the datasource, without any columns or any metadata information.

Using OData with sharepoint Listdata.svc, I receive column metadata when the list is empty, but some columns with more complex data types I don't receive at all (for example, columns that translate to List or Record types while using Sharepoint List Data Source).

Is there any work around or a way to get the correct sharepoint data?

Thank you,

António Baptista

Hello,

I'm getting some sharepoint list data to PowerBI Desktop (lates version) to do a report, but I'm finding some limitations and so far no workaround.

When using the sharepoint online list data source, when the sharepoint list is empty, an empty table is returned, with no column metadata.

When using the odata data source, with listdata.svc, the column metadata is returned when the list is empty, but complex data type columns are not returned (for example, columns that evaluate to List and Record types when using the list datasource).

Is there any work around for getting the correct data from sharepoint?

Thanks,

ambtb,

I am not able to reproduce your issue in the latest version of Power BI Desktop(2.48.4792.481 64-bit (July 2017)). Do you enter the root URL of your SharePoint online site when connecting to the online list using the connector as shown in the first screenshot? And do you use Microsoft account to connect to the online list as shown in the second screenshot?



Regards,
Lydia