PowerBI Integration Query - Accessing passed values

[MarkSL]

Hi there,

I'm pretty new to PowerApps, but hoping the below is understandable...

We want to add a PowerApp visual to our Power BI Report page which will capture selected values from a Power BI table (Sales Person Name, Period, Sales Qty etc) and then have form which will allow the user to add some comments.  When they press Save, I want the selected Sales Person values and the comment from the form to be written to a Sharepoint List.  I am not really bothered about having the Power BI report instantly update with the written record, I simply want to capture the report values and comments into the SP List.

(We would prefer to write the data direct to SQL, however this is a Premium Connector, therefore using a SP List as a 'staging' table before setting up a Flow to move write the records into SQL)

Very basic mock up of the Power BI Report page:

To get the values of the selected Sales Exec and their associated values, I need to start my App from within Power BI by dragging the datafields into the PowerApps visual and then Create the app.

The App which gets launched contains a Gallery which has Items = 'PowerBIIntegration'.Data.  The individual labels display the correct value from the report, eg:  Text = ThisItem.'Sales Person'.   At this point there is no actual data source in the App, my understanding is that the Power values are injected / passed into the app.

I want to now add a form, which is connected to my SP List and populate the fields with the Power Bi values in the Gallery along with some additional comments.  I have started doing this by setting the value to: Gallery1.Selected.'Sales Person'.

Is there a better way to access the Power BI values in the App or is Gallery1.selected the only way?

Thanks

Mark

[v-xiaochen-msft · Accepted solution]

Hi @MarkSL ,

It depends on your needs.

You could think of 'PowerBIIntegration'.Data as a data source.

You could use many controls to display powerbi data, such as gallery, label, form, combo box and data table, etc.

For example:

If you want to use a combo box control to display powerbI data, you could set the Items property of the combo box to:

PowerBIIntegration'.Data

You could also put the data in a collection.

Add a buton control and set its Onselect property to:

ClearCollect(Col,'PowerBIIntegration'.Data)

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.