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