cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
KJanssens Frequent Visitor
Frequent Visitor

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

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

2 REPLIES 2
Community Support Team
Community Support Team

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

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".

 

 

Support Ticket.gifsubmit a support ticket

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KJanssens Frequent Visitor
Frequent Visitor

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

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