Forum Discussion
Tabular Model gives different results than SQL Query
This issue is resolved now. I have partitions on some tables in our Model and the date I was partitioning on was the wrong date, so the records were being counted in both partitions instead of having the entire record sitting in only 1 partition.
Here is the raw data for this "Call." The only thing that stands out to me is that Offer #5 happened the next day (which is a valid use case). The OfferTransportCount field is just a whole number value. If i just import this data set to Power BI, the data looks fine, but for some reason, when i pull the data from our Model, it gives a TransportCount to Offer #4. I am using the exact same query when pulling the data directly from the database and as the source query for the tabular model table. Does this help at all?
| CallNumber | OfferDate | OfferTime | OfferOrder | OfferTransportCount |
| 19-11988A | 2019-04-30 | 18:07:21.0000000 | 1 | 0 |
| 19-11988A | 2019-04-30 | 18:07:38.0000000 | 2 | 0 |
| 19-11988A | 2019-04-30 | 18:11:43.0000000 | 3 | 0 |
| 19-11988A | 2019-04-30 | 18:11:53.0000000 | 4 | 0 |
| 19-11988A | 2019-05-01 | 00:42:02.0000000 | 5 | 1 |
This issue is resolved now. I have partitions on some tables in our Model and the date I was partitioning on was the wrong date, so the records were being counted in both partitions instead of having the entire record sitting in only 1 partition.