The Results of Query is not the same in My SQL and Power BI

[rhashhab]

I have noticed a sudden probelm in my Power BI report. The results of My SQL query when I run it on My SQL is not the same when I connect the same query to Power BI. It gives me different results for some rows.

[v-henryk-mstf · Accepted solution]

Hi @rhashhab ,

Did you try to use the same sql query at the following location when connecting to the data source and see if the data displayed after the connection is always the same?

Also what is your join mode and the specific query statement, this cause can be a problem due to query folding.

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rhashhab , You need to share an example. Power bi data is by default grouped. So row will grouped based on not summarized columns and data will aggregate for numeric /summarized columns

[rhashhab]

For example , when I run the SQL query on SQL , it gives me the following :

For date 2022-01-01 , the number of transactions is 10. 

However, when I run the same query on Power BI, it gives me for the same row : for date 2022-01-01 , the number of transactions is 5.