Embedding a Power App in PowerBI issue - data not moving over

(0) Share

Report

Posted on by VS-11032329-0

I have created a PowerApp that I want to embed in PowerBI. I am trying to get the ID number to pass over to the app for a tracking form when a row on a PowerBI matrix visualization is chosen.

I was able to get the PowerApp into PowerBI and when using a CountRows formula on the App, could see the number change from 1000 to 1 when a record was chosen but no data was being passed. I added a JSON record to see what was being passed - nothing. I added a calculated column to see if that would pass through - no.

I updated my column from Whole Number to Text to see if that would fix it but it didn't. I created the app in the PowerApp visualizer instead of using an already created one but that didn't work. I tried using a blank app to see if any of the set-up in my app (which I changed around A LOT) made a difference but neither version could get data passed to it. The PowerBI integration exists on my layers tab so some kind of connection is established but I can't do anything with it.

I feel like there is probably some setting / box / hidden thing that I'm missing to get the two products to data sync but I can't figure out what it is. AI told me to check that the products are in the same environment / region and they are.

I've watched a few videos on how to set this up and according to them, everything looks good. The matrix visualization in PowerBI does have 7319 rows and I know that there is a throttling issue with PowerAutomate but I haven't seen anything with these products since I am using First in my code for PowerApp so even if there is a throttling issue, I am only trying to bring over the first instance. Some data appearing should occur.

Any suggestions of things to check would be really helpful.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Did you add the Power App visualization to the Power BI report and choose the field you want Power BI to pass to the App? The fields specified in the Power App visualization are what the Power BI integration object shows in the Power App.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
VS-11032329-0 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I added the one field I wanted. Then I also matched exactly the same ones that were in the matrix in case it needed to be the same. Neither moved anything over.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@VS-11032329-0 In the app are you seeing a PowerBIIntegration object in the control tree? That is where the values being passed are surfaced as properties. If you aren't seeing that object then it might be because you created the app on its own. It should have been added when you chose it from the Visualization in Power BI. If you want the selected row in the Matrix to be passed then you need to setup the PA visualization with the same data and filter as the Matrix.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
VS-11032329-0 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Yep, PowerBIIntegration object is in the control tree - on both attempts (the app I created previously and the new app I built at the time of Visualization being added.

When you say that the filters need to match, can you explain more on that?

The matrix has about 10 possible filters but those are filtering the matrix table itself. For the PA, just wanted it to pass the one record when highlighted. After adding the PA, used the Edit Interactions to make sure it was filtering off of the matrix but that's the extent of filtering - just making sure that the filter was active on the PA.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If the PA visualization is using the same filters as the Matrix Then selecting a row in the Matrix should also select it in the PA Visualization. That row would then be passed as part of a array in the PowerBIIntegration object. But it always comes as an array of records, even if there is only one. One way to check is to change the PA Visualization to a Matrix and make sure its picking up the filters. Then switch it back.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
VS-11032329-0 16 on at

Like
a
(0)

Report
Copy link

Link copied!

I checked that and yes, the ID is filtering correctly. When I changed it to a matrix, I could see the ID field and see it filtering correctly. It just won't appear.

I am using the code First(PowerBIIntegration.Data).ID as the Default on the DataCard in my Tracking Form but it does not populate any information when the row is clicked.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

My only other thought would be to check the data type of the ID coming into the app. It may be an int coming in as a string which is then lost when cast to a different data type.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
VS-11032329-0 16 on at

Like
a
(0)

Report
Copy link

Link copied!

The data type for that card is Text and we have tried it as Whole Number and as Text in the PowerBI matrix.

I have never tried to cast a datatype in PowerApp. Is there a formula you recommend to try? Maybe explicitly forcing a cast could work.

Was this reply helpful? Yes No
Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

int() would be the function to cast a string to an integer, which is what ID normally is.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
VS-11032329-0 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried casting as:

int(First(PowerBIIntegration.Data).ID)

Didn't work. There seems to be no rhyme or reason to why this is not showing up properly in the Default of the field I'm trying to show it in.

Was this reply helpful? Yes No