PowerApps and PowerBI integration

[mrothschild]

PBIX link: https://www.dropbox.com/s/3bhks3t4x90h7sj/FlooringEstimates.pbix?dl=0 

I've created the FlooringEstimates app in the PowerApps tutorial described here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-gallery

In my powerBI, I have a simple table that shows Flooring Name, Category, and Price per SF.

I manually entered data in a different table that shows name, SF sold and date sold, and linked the two tables together by Name.

I creased a Card Visual to show Revenues, which equals SF sold * Price Per SF.  

The Card visual adjusts when I click on a row of the table, just like normal PowerBI.  What I'd like is for the entire screen to be integrated, such that, when I click on the PowerApps Visual, it effectively selects the row in the table, and then recalculates the Card visual accordingly.  From the screenshots below, the Card shows 501k of revenues.  Then when I select the table row for [Name] = "Alpha" the card recalculates to 5497.  Then when I unselect [Name] in the Table, but select Alpha in PowerApps, the Card Visual resets to all rows, but I'd like it to flow through such that the card output is 5497.  Is this possible?

I have figured out how to do this in reverse, where a slicer in BI can manipulate the PowerApps, but I want the PowerApps to effectively be the slicer for BI.

Screenshots below:

[v-lili6-msft]

hi, @mrothschild 

I would suggest you post the case in PowerApps forum, there will be many PowerApps experts could help you.

Best Regards,

Lin

[mrothschild · Accepted solution]

I came across this walkthrough (and associated 3 minute video with link therein) which facilitated getting closer to the result I wanted.  Not quite perfect, but working more closely as intended now.  

https://blogs.msdn.microsoft.com/charles_sterling/2018/01/05/walk-through-of-using-the-powerapps-cus...

I've been stairstepping my way through this, but I think the two keys were:

(a) changing OnSelect associed with the right arrows on the Summary Gallery with "Select(Parent)" & Navigate([new screen],ScreenTransition.None) and 

(b) having two different Galleries, the one with the Summary Data with Items set to PoweerBIIntegration.Data and a second Gallery referenceing the first, which is set to: Filter(Portfolio_Inputs,'PowerBI Gallery'.Selected.'Asset ID'='Asset ID') 

Note that in this case, the second Gallery is referencing the table in the Excel spreadsheet - in this case called "Portfolio_Inputs" - that is the source of the PowerBI data