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

[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.

[LuizVicente]

Hmm.. try this:

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

[PitawatN]

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

[PitawatN · Accepted solution]

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.

[v-liwei-msft]

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

[Aron3]

Where did you make the change?

[PitawatN]

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.

[StevenRichards]

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.

[EddieE]

@PitawatN 

Thanks mate! You just saved my afternoon of Googling haha

[BIDev123]

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?