Power BI REST API - Microsoft changed the parameter of JSON

[lawrenceabith]

Hi @TedPattison, How are you! Happy New Year!

We followed your instructions below and the functionality to "Drill Through with just one click directly in the chart" works well in our app until yesterday. Something change in the json format and everythigs stoped to work. We found and solve the problem but we need to have sure that this doesn´t happining again. Can you help us?

Before yestarday we use this property to get the parameter on the click.

-> data.dataPoints[0].values[0].formattedValue

Now we use this to solve the problem.

-> data.dataPoints[0].identity[0].equals.toString()

Do you know if have another way safe to get this?

Many thanks,

Regards,

[v-shex-msft · Accepted solution]

Hi @lawrenceabith,

It seems like something changes on the formattedValue properties and your values cannot racingzone correctly.

In my opinion, I 'd like to suggest you to add some additional steps for verify and convert extract values.

For example: 

You can add some statements to check current return value and add error handle steps and corresponding data conversion processings.

JavaScript check if variable exists (is defined/initialized) 

JavaScript Errors - Throw and Try to Catch 

Regards,

Xiaoxin Sheng