Query is giving different results between Power BI and Dataflow

[Kinger2129]

I built a model in Power BI desktop and then moved it to a Dataflow (Gen 1).  When I directly connect to a specific query in the Dataflow either through Excel or Power BI desktop I am getting different results. For example, ID 1389 is filtered out in the original query built in Power BI and if I go into the edit screen in the Dataflow and filter by ID 1389, it is filtered out as expected. However, if I connect directly to the query in the Dataflow via Excel or Power BI, the ID 1389 is coming through. I cannot figure out why what I see in the Edit view in the Dataflow does not represent what is coming through when I directly connect to the query in the Dataflow via Excel or Power BI. (I have refreshed the models multiple times) Anyone else had this issue?

Screen shot of Power BI directly linked to the Dataflow, filtered by 1389 (I was expecting it not to find the record 1389)

Screenshot within the Edit view in the Dataflow, filtering by 1389 (cannot find the record, which is what I am expecting)

[Kinger2129 · Accepted solution]

Unfortunately I was unable to resolve the issue with how the model was built, therefore, I ended up rebuilding it with a slightly different approach and was able to get it to operate as required. My guess as to why I was seeing the issue is that there was a merge step in the query that was a one to many relationship. I think while in the Dataflow edit screen, it was showing the items filtering out, but when connecting to the Dataflow via Excel, it was showing different results due to the one to many merge.

[v-bmanikante]

Hi @Kinger2129 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@SaiTejaTalasila @SreeniBattula Thank you for your response.

@Kinger2129 We would like to follow up to see if the solution provided by the super users resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[SaiTejaTalasila]

Hi @Kinger2129 ,

As per my understanding, this should not happen. You might be connecting to a duplicate dataflow located in a different workspace, or the filter condition might be incorrect. Please review them once more. If possible, please share the M query you're using on the dataflow.

I hope this helps.

Thanks,

Sai Teja 

[SreeniBattula]

You have many steps before this perticuler validation in  your Dataflow, please  check those steps are filtering out this.