Power BI REST API - Microsoft changed the parameter of JSON

lawrenceabith — Tue, 12 Jan 2021 12:55:24 GMT

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,

Re: Power BI REST API - Microsoft changed the parameter of JSON

Anonymous — Thu, 14 Jan 2021 08:10:24 GMT

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

topic Re: Power BI REST API - Microsoft changed the parameter of JSON in Developer

Power BI REST API - Microsoft changed the parameter of JSON

Re: Power BI REST API - Microsoft changed the parameter of JSON