cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Axal
Super User
Super User

Power BI integration : common field

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

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xida-msft
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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,

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,735)