Power BI integration : common field

[Axal]

Hello everyone,

Firstly I'm afraid I couldn't elaborate well about the issue, but let me try.

So, I create a blank canvas for sending email with PowerApps. There is no data source attached other than Office365 Users and Office365 Outlook.

Next step I want to use it from my Power BI report. So I added this PowerApps from Power BI Services, drag a column from one of my Power BI table, lets say Employee, the fields is "Name", then add my existing PowerApps and edit it. Under PowerApps studio, I can see new node : PowerBI Integration added into my apps, and in one of my Textinput, I added PowerBI value in its Default :

First([@PowerBIIntegration].Data).'Name'

It's working well at first. inside Power BI report, I can use my apps with value "defaulted" from Power BI table. However actually this Apps intended to be general purposes, used not only for Employee. I have other table which has "Name" as well, and would like to have the same "sharing value"

For example, if I'm using / displaying table Customers, I would like to pass its "Name" to my apps and use it.

Currently, this not working. In my understanding, it is because at first, the connection, PowerBI Integration is build with Employee : "Name" not Customer : "Name"

How am I going to use it with any table I have with "Name" and pass it to the same PowerApps ? Later I may need to pass Vendor's Name or maybe other table which has a person's name. Any addition code I should put inside my apps ?

Thanks,

Axal

[v-xida-msft · Accepted solution]

Hi @Axal ,

Could you please share a bit more about your scenario?

Do you want the embedded canvas app to reference same column name from different tables in your Power BI report?

Based on the issue that you mentioned, I agree with you. I think the PowerBIIntegration you set up in your embedded app is based on the Employee Table rather than Customer Table, so the embedded canvas app could not recognize the same column name from your Customer table.

As an alternative solution, please consider remove the PowerApps Custom Visual from your app, then select the Name column from your Employee Table and Name column from your Customer Table together, then re-add a new PowerApps Custom Visual in your Power BI report, then create a new canvas app, check if the issue is solved.

If the issue still exists, I afraid that referencing same column name from different tables in your Power BI report is not supported within the embedded canvas app.

If you would like this frature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

[Axal]

Hi Kris,

Thanks, it's works. I removed my visual and add again my PowerApps. Doesn't need to create new canvas, it turns out just fine.

Thanks again for your support.

Cheers,