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.
You didn't give enough information about the structure of your form & list.
If I change a column from a String to a Currency, I get the same error onload of my form. That is whether I am filling in the field like this:
txtMyFirstField.Text+txtMySecondField.Text+txtMyThirdField.Text
or like this:
If(IsBlank(txtMyFirstField.Text+txtMySecondField.Text+txtMyThirdField.Text),
0,
txtMyFirstField.Text+txtMySecondField.Text+txtMyThirdField.Text
)
or this:
If(IsBlank(Value(txtMyFirstField.Text)+Value(txtMySecondField.Text)+Value(txtMyThirdField.Text)),
0,
Value(txtMyFirstField.Text)+Value(txtMySecondField.Text)+Value(txtMyThirdField.Text)
)
(You'd think with them all being the same type, no issue, right? HA.)
What I had to do instead was:
1. Change my Currency field where totals were going to into a String field type on the list, instead
2. Update that same field in my Power Apps form to have a Format = Text
3. Used this in my Default:
Text(txtMyFirstField.Text+txtMySecondField.Text+txtMyThirdField.Text,"[$-en-US],$##,###.00")
So it will just get set as a currency format from the value in the field, on save, from the form, itself.
I'm thinking this HAS to be a bug within Power Apps, that we have to set the field as a String field on the list and can't write a number to a Currency field. Especially when I'm doing exactly this from user-input directly into the 3 fields I'm specifying ("My First Field", "My Second Field", "My Third Field") that are all Currency fields and take values from the user just fine. Utterly ridiculous!
I am getting the info icon as below when just navigating to the page itself. Is there any way to resolve this.
Sorry, no, I can't help with that.
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?
Thanks mate! You just saved my afternoon of Googling haha
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.
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.
Where did you make the change?
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
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473