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!

[v-jiewu-msft · Accepted solution]

Hi @Anonymous ,

If I understand correctly, the issue is that you had the error with the data values not matching. Please try the following methods and check if they can solve your problem:

1.You can try to refresh the dataflow to see if the issue exists.

2.Going to options and clear the cache.

3.Check that the data types for the Name column in both datasets are consistent.

4.Ensure that there are no differences in the DAX formulas.

5.Check the relationships between tables in the new data model.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format or screenshot to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your reply.

Best Regards,

Wisdom Wu