After Data source change, BI is double counting Everything

[Anonymous]

Hey all!

Working with a client (who is very protective of data and won't share the file with me) and They have run into a problem where when they switch a file that has same exact headers and everything just different data, powerbi is double counting.

EX: the backend excel will show 1 million impressions but in BI it will show 2 million impressions.

I have never seen this before and not sure why this is happening. any idea why or have any of you had the same issue and fixed it?

Thanks!

[v-jiascu-msft]

Hi @Anonymous,

There is a similar thread several days ago that was found out the issue in the data source. Please refer to Duplicate-data-after-database-password-reset.

To be honest, this is very uncommon. 

1. What's data source exactly? Does it have the right data?

2. What's the symptom? The data is doubled in the Query Editor? Or the measure returns wrong result?

3. What did it look like in the Data pane?

4. How did they switch the file?

Best Regards,

Dale

[Anonymous · Accepted solution]

 Hey @v-jiascu-msft

I figured this was very uncommon and I am guessing a rare bug.

The data is right on their end. The column names are exactly the same file to file just different values. 

The results are being returned doubled of what they should be. When pivoted in excel the impressions for example are half of what is shown in power BI.  As far as switching the file, I actually asked them but havent heard back. I am assuming they used the file>option and settings> then changed the data source. I recommed that they try switching the data source file from the query editor to see if that changes anything so waiting on that test. 

Another weird thing I noticed was that when they hit the query editor on the main ribbon, nothing would show up. The would have to right click on the fields pane on the table to enter the query editor and get data to show up.