Data Values not Matching

[Anonymous]

Hello, Seeking an answer to my current issue/s i'm facing. not sure if anyone has experience this before.

For context:
My Power BI Report is connected to a PBI Finance Dataset. now, i changed the data source from PBI Finance Dataset to "PBI Finance Dataset - Dataflow".

now, the issues are, some visualls are not properly representing the data, and error says about the Customer Details Table

In the PBI Finance Dataset - Dataflow (which is the new data source), relationships and calculation is the same with PBI Finance Dataset (Old).

-error says, Customer Name in the Customer Details Table details not found. so the workaround i have made is, instead of 'Customer Name' i used the "Name" column in the Customer Details Table (which is fine because it represents same data in the old data source which is the PBI Finance Dataset)

- PBI Finance Dataset DAX was Distinctcount(CustomerDetails[Customer Name]) vs. PBI Finance Dataset - Dataflow, Distinctcount(CustomerDetails[Name])  - I now iused the 'Name' Columns since it is the same with the old datasource.

Now, I still don't get the exact match for this visual (Old Data source showing 238 while the New Data source showing 3,000 customers) even the logics are the same, and relationship has been established as well.

Appreciate your help if i missed anything on this process. thank you!

[BA_Pete]

Hi @Anonymous ,

Very difficult to give a decent answer without seeing each of the different models and relationships, measures, required outputs etc.

It's clear that the two sources are not the same but, where that difference is without being able to see/compare is anyone's guess.

It might be worth you having a look at a comparison tool, something like ALM Toolkit? I believe this can put two models side-by-side and compare them line-by-line, but I've not used it myself tbh.

If that's not an option, then I'd be checking things like measure definitions, use of DAX calculated columns etc.

If you're not the author and these two sources are supposed to be identical, then all of this will need to be pushed back to them, I think.

Pete