Forum Discussion

aruna_jayapaul's avatar
aruna_jayapaul
New Member
1 year ago
Solved

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 co...
Need Help
  • aruna_jayapaul's avatar
    aruna_jayapaul
    1 year ago

    Issue got resolved after updating the function like below,

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

     

    Thank you!

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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's avatar
    aruna_jayapaul
    New Member
    1 year ago

    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.