JSON parsing error msg in Power BI

[aruna_jayapaul]

Hi,

I need some assistance in power app. I 'm trying to use power BI measure for the label in Power APP, but the measure is returning a blank value. To address this, I applied some function to convert blank values to Zero.

However after importing the same power app back into Power BI, the zero's are being reverted to blanks again.

This appears to be causing a data type conversion issue, resulting in a JSON parsing error

Could someone please advise on how to resolve this?

Thank you,

Aruna J

[aruna_jayapaul · Accepted solution]

Issue got resolved after updating the function like below,

If(IsBlankOrError(First(PowerBIintegration.data).YourMeasure), 0, First(PowerBIintegration.data).YourMeasure)

Thank you!

[rajendraongole1]

Hi @aruna_jayapaul  - you can verify that the data type of your measure in Power BI is compatible with Power Apps (e.g., Decimal Number, Whole Number, or Text, depending on your need).Avoid ambiguous data types, such as automatic conversion between number and text.

JSON Online Validator and Formatter - JSON Lint

Ensure that the column or measure exported from Power BI to Power Apps is formatted consistently (e.g., ensure no hidden blank/null values).Use the IF or COALESCE function in your DAX measure

Hope this helps.

[aruna_jayapaul]

Hi @rajendraongole1 , Already i have set the dataype of the measure to whole number in power BI. And i have used if condition in the measure to convert blank to Zero's if any.

[bhanu_gautam]

@aruna_jayapaul , Try using this in Power Apps

If(IsBlank(ThisItem.YourMeasure), 0, ThisItem.YourMeasure)

[aruna_jayapaul]

Thanks Bhanu_gautam for your input. Thisitem is not working for me. I have used calculation like below,

If(IsBlank(First(PowerBIintegration.data).YourMeasure), 0, First(PowerBIintegration.data).YourMeasure). 

Still am getting blank in Power BI