Showing results for 
Search instead for 
Did you mean: 
New Member

PowerBI Integrated Multiple Tables Canvas App

Hi ,

I am working on PowerBI Integrated PowerApp with On Premise SQL server being the destination/underlying server.

I have two sections/two visuals where I need to enable CRUD operation directly from PowerBI Dashboard. Lets Say two sections are 1)Takeaways- SQL table

2)Actions - SQL Table

I have been able to design Takeaways quite okay with Insert/Read&Update Operations however when I am trying to drag and drop fields from Actions table into PowerApps Visual from PowerBI dashboard it just doesn't allow me. It throws this error below however both tables have primary key(id) and I can join them in SSMS and view data even though result set is a Cartesian Product

Can't determine relationships between the fields
Can't display the data because Power BI can't determine the relationship between two or more fields.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 77df593f-7710-4435-913f-44242122b693
Request ID: 61500fb3-6f84-9925-fde8-4b4e7fdddfaf
Correlation ID: 216b924f-146b-3e83-f677-97a560f6a307


I want to create one app which will display data for both tables for read & update operations.

I am able to include Insert(Edit Form) for Actions table connecting to SQL table which is straight forward however I want to bring data from PowerBIIntegration.Data for both Comments & Actions so that I can provide individual screens for display and edit forms ... You may refer to attached screenshot for what I am trying to achieve


Please guide me and let me know of a hack from your expertise

thanks in Advance



Community Champion
Community Champion

Hi @ArcherJayden17 ,


sorry to say that, this is for Power App developer issues forum, the right forum to get better help is:


I hope this resolved your issue if you see any challenge let me know I am always happy to help.


If this post helps, then please consider Accept it as the solution and give thumbs-up to help the other members find it more.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
Community Support
Community Support

Hi @ArcherJayden17 ,

Do you want to drag fields from different tables (dataset) into the PowerApps Custom Visual in your Power BI report?

Have you set up relationship between your Takeaways table and Actions table in your Power BI desktop?


If you want to connect the PowerApps Custom Visual to fields in different tables, please make sure you have set up relationship between these tables firstly as below:



On your side, please consider set up relationship between your two tables firstly. Then add a new PowerApps Custom Visual in your Power BI report, and drag fields from your two tables into this PowerApps Custom Visual.


In addition, you could also consider merge your two tables into a single one table based on the relationship. Then add a new PowerApps Custom Visual in your BI Report, and drag fields from this merged single one table into this PowerApps Custom Visual.


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 @v-xida-msft,

Thank you for guidance. You have identified the issue accurately ! 

I have done this exactly what you said by joining two tables at Powerbi and then I am able to bring those fields into PowerApp.

Now I am stuck with another predicament where my key takeways are producing cartersian values(duplicates) per Action plan because I have mutliple action plans for each item.

how can I resolve and show just distinct values at powerapp specifically in my takeaways browse gallery ?

Did you find a workaround for this? I am also facing this issue.

Helpful resources

Ignite 2022


Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,035)