OData JSON error (same query works in Excel but not in PowerBI)

[KJanssens]

I have the following query in Excel (source url a bit obfuscated):

let
Source = OData.Feed("https://xxx.timehub.7pace.com/api/odata", null, [Implementation="2.0"]),
#"TimeExport_function" = Source{[Name="TimeExport"]}[Data],
#"Invoked FunctionTimeExport_function" = #"TimeExport_function"("2019-01-01", "2020-01-01", false, false, true)
in
#"Invoked FunctionTimeExport_function"

it works fine, I get all data I need

However, when I use the same query in Power BI Desktop (Version: 2.67.5404.801 64-bit) it throws the following error:

DataSource.Error: OData: Invalid JSON. Unexpected end of input was found in JSON content. Not all object and array scopes were closed.
Details:
    DataSourceKind=OData
    DataSourcePath=https://xxx.timehub.7pace.com/api/odata/TimeExport(startDate='2019-01-01',endDate='2020-01-01',populateTopParentColumns=false,groupTimeByDateByUser=false,includeBillable=true)

Why is PowerBI throwing this error and Excel not?

Thanks,

Koen

[v-lili6-msft]

hi, @KJanssens 

If you only have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

submit a support ticket

Best Regards,

Lin

[KJanssens]

I do not have a Pro license, so I cannot make a support ticket... 

Regarding that, as a consultant, I am helping other companies with their BI needs. Since we do not need BI within our own company, iss there any way I can get a developer license of Power BI Pro (similar to a SQL Server Developer license)?

Thanks,

Koen