Answered

"JSON parsing error, expected 'number' but got 'string'" error in embedded Power Apps in Power BI report

(1) Share

Report

Posted on by PitawatN

I'm new to both Power Apps and Power BI. I'm trying to do the write-back where I click on Power BI charts and it changes data in Power App and editing the data in Power Apps also saves the data back to data source.

Now my app is ready. In Power Apps Studio, the data shown in app changes dynamically when clicking on the Power BI report charts. This indicates that Power Apps and Power BI are connected.

However, in the embedded Power Apps section in Power BI report, it shows red error banner saying "JSON parsing error, expected 'number' but got 'string'." then it disappears and my Power Apps gallery doesn't show any data. I tried removing the embedded Power Apps from Power BI report and added it back again, select existing app and publish the app again, but still got the same error.

Please advise. I'm not sure if this is the error from Power Apps or Power BI or if this is the right place to ask. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

LuizVicente 984 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hmm.. try this:

"type": ["integer", "string"]

Was this reply helpful? Yes No
PitawatN 43 on at

Like (1)

Report
Copy link

Link copied!

Hi @LuizVicente, thanks for your reply. But where exactly should I put that line?

Was this reply helpful? Yes No
Verified answer

PitawatN 43 on at

Like (11)

Report
Copy link

Link copied!
I have solved the problem. Turns out the data from Power BI has some values as 0 and Power Apps sees it as blank or string or something hence the error on Power BI. Weird that it runs perfectly fine in Power Apps Studio.

I had to handle the value 0 by using:
If(IsBlankOrError(Value),0,Value)
This will make sure the value, whether blank or zero, will be number zero.

2 people found this reply helpful.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @PitawatN

Glad to see you solved the problem.

You could mark your answer/solution as a 'Solution' to allow more people with the same problem to solve their own problem as quickly as possible.

Thank you so much!

Best Regards,

Levi

Was this reply helpful? Yes No
Aron3 5 on at

Like (0)

Report
Copy link

Link copied!

Where did you make the change?

Was this reply helpful? Yes No
PitawatN 43 on at

Like (1)

Report
Copy link

Link copied!

As I mentioned in my reply above, I had to handle all zeros and/or blank values from Power BI. So to answer your question of "where", I'd say everywhere the app is using said values.

1 people found this reply helpful.

Was this reply helpful? Yes No
StevenRichards 155 on at

Like (3)

Report
Copy link

Link copied!
Not sure if you're still look
Collect( colSparePartsList, { ContractNumber: ContractNumber.Text, QuantityReceived: If( IsBlankOrError(QuantityReceived.Text), 0, Value(QuantityReceived.Text) ), QuantityRequested: QuantityRequested.Text, QuantityShipped: QuantityShipped.Text, PartsBoxNumber: PartsBoxNumber.Text, Description: Description.Text } )
ing for an answer but in my case I had to collect it.

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@PitawatN

Thanks mate! You just saved my afternoon of Googling haha

Was this reply helpful? Yes No
Warric 3 on at

Like (0)

Report
Copy link

Link copied!

Hi @StevenRichards , I dynamically pass my coloumns from PowerBi to Powerapps.

Is there any way to dynamically pass the column names to your formula, I have the column names in a collection?

Or is their anyway to remove all blanks from a collection without using column names?

Was this reply helpful? Yes No
StevenRichards 155 on at

Like (0)

Report
Copy link

Link copied!

Sorry, no, I can't help with that.

Was this reply helpful? Yes No