Unanswered

Data from Power Bi with multiple Tables

(0) Share

Report

Posted on by SmlLkf

In my app I need data from different tables from Power Bi.
e.g. from the tables Companies and Employees (Yes, there is a relation between theses tables)

Now I can add the fields to the visual in Power Bi.
If I activate only data from one or the other table, everything works. However, I can then work with the data from the Company table, for example. The data from the Employees table is not available to me. If I activate data from both tables, there are multiple problems. In the gallery the companies are displayed multiple times and Distinct() is also a problem in this case. And also I miss many data, if I select fields from different tables.

I would prefer if I could access the datasets from the Power Bi report directly. Is that somehow possible?

I have also tried the connector for PowerBi. However, it is not possible to access the datasets from the reports.

Or maybe there is a way to group the data which is given from Power Bi to the visual and I can access this data like PowerBIIntegration.CompaniesTable and PowerBIIntegration.EmployeesTable

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

rimatos on at

Like (0)

Report

Hi @SmlLkf ,

Could you show us some screenshots on how you are integrating your PowerBI tables with the canvas app? What is the output that you are receiving and what is the expected result?

You can refer to our official documentation for embedding PowerApps with PowerBI. Additionally, you can also refer to other external guides, on how to achieve this.

Regards,

Ricardo

Was this reply helpful? Yes No
SmlLkf 2 on at

Like (0)

Report

Hello Ricardo,

thanks for your answer.

Using the visual I unfortunately only get the data in one merged table. Via the source PowerBiIntegration I get exactly this data.
It would be much more comfortable to get the data in its structure with all relations from the Power Bi datasets directly. Is it somehow possible that I can address the datasets? So e.g. via PowerBiConnector.DatasetTable1 and not only the data, which the visual provides me via PowerBiIntegration.Data?

I would be very happy about this possibility!

Was this reply helpful? Yes No
Kaushik_Patel 2 on at

Like (0)

Report

Were you able to solve this? I am facing the same issue, which is, when we pass columns from more than one table from Power BI into the Power Apps visual, it does a cartesian join instead of joining the tables based on relationships defined in the model

Was this reply helpful? Yes No