Power BI shows wrong data

[Dominik_D]

Hello

I created a Power BI dashboard, but it shows my data incorrectly. Power BI has been connected to CRM and data is correct. 

In the picture you can see the "quoteid" and that the first 3 rows of the first table have the same quote id. That means it's the same listing 3 times.

Picture Dashboard

Why is it three times now?
As soon as I display two more tributes in the table, more precisely the architect and Eletroplanner, the data is falsified. A data set is created with only architects, one with only Elektroplanner and one without both. You can see that in the picture, too. The relationships are set correctly. 

What could be the problem?

The first show and/or last show setting does not work, because then the other offers without architects disappear. However, 3 data sets become one, that would be correct. 

Thank you for your Help 

[v-pnaroju-msft]

Hi Dominik_D,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi Dominik_D,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi Dominik_D,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @amitchandak , @danextian, for your response.

Hi @Dominik_D,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Based on my understanding, when you add the Architect and Elektroplaner fields directly to your table visual in Power BI, it results in multiple rows per quote for each unique combination of those fields. Consequently, this may create the appearance of duplicate quotes.

Please follow the steps outlined below, which may help resolve the issue:

1.Use DAX measures to aggregate the Architect and Elektroplaner names:

Architect List = CONCATENATEX(VALUES('ArchitectTable'[ArchitectName]), 'ArchitectTable'[ArchitectName], ", ")
Elektroplaner List = CONCATENATEX(VALUES('ElektroplanerTable'[ElektroplanerName]), 'ElektroplanerTable'[ElektroplanerName], ", ")

 
2.Use these measures in your table instead of the raw fields. By doing so, each quote will appear only once while still displaying all related names in a comma-separated format. Alternatively, you may consider using a Matrix visual or restructuring the model to further reduce duplication.

Additionally, please refer to the following link for guidance:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[danextian]

Hi @Dominik_D 

Is your URL a measure? If so what is the formula?

[amitchandak]

@Dominik_D ,Can you share the Model diagram in Power BI, with the relationship between the two tables?