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.
Hi jbirrer ,
Could you please share the formula you are using to generate "OfferTransportCount" if it does not contain any confidential information? Is there any record in your datatable that OfferOrder=4? Please don't have any Confidential Information or Real data in your reply.
Best regards,
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.