Power BI with Sharepoint issues

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,