Power Bi with Project web App - JSON Error

[NotAlways42]

Hello,

I am evaluating data of an project in PWA with Power Bi. I have set up several customs columns and the project snycs to task list in share point.

Recently I am getting an error when refreshing the data set:

„DataSource.Error: We couldn't parse OData response result.  Error: Invalid JSON. A comma character ',' was expected in scope 'Object'. Every two elements in an array and properties of an object must be separated by commas.

Details:

    DataSourceKind=OData

    DataSourcePath=https://vattenfall.sharepoint.com/sites/RsNordicPlanning/_api/ProjectData/[en-us]/Tasks"

The error occurs only with the task list.

Cany anybody bring me on the way, how to approach this error please. I have been looking for invalid entries, but until now without success.

Is there any way to see the data, that are causing the error during refresh?

Thanks ahead for any suggestions that could help,

Rgs Felix

[v-kelly-msft]

Hi @NotAlways42 ,

Check the similar thread below:

https://community.powerbi.com/t5/Service/Power-BI-Desktop-Error-Message/m-p/623381

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[NotAlways42]

Hello Kelly, thanks for your reply.

I found that thread too, but I can not just delete a project from our portfolio. 

That is reason, why I hoped, that somebody could give me a hint, how I can find out, which data are actually causing the error. An error log would be great...

I have searched for unvalid entries but until now without success.

Rgs Felix

[v-kelly-msft]

Hi  @NotAlways42 ,

Check the below thead of json code issue:

https://stackoverflow.com/questions/27011489/what-is-the-correct-json-to-pass-to-an-action-which-acc...

It should be a comma error,hope this help.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!