Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
NotAlways42
Frequent Visitor

Power Bi with Project web App - JSON Error

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

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

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!

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

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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.