Forum Discussion
JSON parsing error msg in Power BI
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
Issue got resolved after updating the function like below,
If(IsBlankOrError(First(PowerBIintegration.data).YourMeasure), 0, First(PowerBIintegration.data).YourMeasure)
Thank you!
5 Replies
aruna_jayapaul , Try using this in Power Apps
If(IsBlank(ThisItem.YourMeasure), 0, ThisItem.YourMeasure)
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
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.
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.
Issue got resolved after updating the function like below,
If(IsBlankOrError(First(PowerBIintegration.data).YourMeasure), 0, First(PowerBIintegration.data).YourMeasure)
Thank you!
