Power Bi service shows different data in a table visual than in Power bi desktop.

[Raj_47220]

I am creating a table visual using columns from Table A and Table B (Relationship bw table A and B is M:M). Once I publish the data to power bi service, the table visual in power bi service shows me extra records.

[Bipin-Lala]

Hi @Raj_47220,

Based on the information provided, it's challenging to pinpoint the exact cause of the issue. However, here are some suggestions to troubleshoot and potentially resolve the extra records appearing in your table visual in Power BI Service:

1. Check for any discrepancies in filters between Power BI Service and Power BI Desktop. Ensure that the filters applied in both environments are consistent and do not cause unintended data display differences.

2. Verify that the dataset is refreshing correctly in Power BI Service. Refresh issues can sometimes lead to data discrepancies, including extra records being displayed.

3. . Since you mentioned it's a many-to-many (M:M) relationship, ensure that the relationships are set up correctly and that they are not causing duplication

It would be beneficial to share more details such as screenshots of the visuals, data, or even the PBIX file itself. This additional information would enable the community to investigate the issue more thoroughly and provide targeted suggestions to address the problem.

Let me know if you have any questions!

[Raj_47220]

thanks for the response @Bipin-Lala 

1. I have checked the filters between Power BI Service and Power BI Desktop and there are no discrepancies.

2. Dataset has been refreshed successfully.

3. If M:M is causing duplication then it should happen in Power Bi Desktop also. Why it is happening only in Service.

Would be happy to hear back from you Sir.

[Bipin-Lala]

Hi @Raj_47220,

Well, if that's the case, I believe you would need to share some more information about the data to investigate further such as screenshots of the visuals, data, counts, or even the PBIX file itself. The details that you have shared till now aren't enough to pinpoint the cause of the issue and explore potential solutions.