Different number of rows in the exported file once direct query was changed to import mode

[RolandTi]

I have built a PBI report on top of direct query. (The report contains just a table chart with more than 100 columns. When I exported the data, I was getting 6948 rows)

When I have changed the storage mode to import and loaded the data I got extra rows in case of import mode. (Nothing else has been changed. When I exported the data, I was getting 6975 rows)

What can cause the 27 rows differences?

Nothing else has been changed, just the storage mode for all of the queries. (The report contains 4 queries, they are connected together with many to one relationships. Cross filter direction is "Single")

All of the columns coming directly from the source, which is Databricks. So the calculated columns or measures cannot cause the issue.

What can happen in the background?

Thanks for your help in advance.

[parry2k]

@RolandTi can you share the relationship diagram? Are you using any measure in the visual?

[RolandTi · Accepted solution]

Hi @parry2k ,

I was able to find the differences and able to solve it. I don't use any measures.

Power BI handles the decimal numbers in some cases on a different way in case of direct query and import mode.

Let's see on the screenshots (03-04 and 03-05):

import mode:

direct query:

Rounded the numbers to 8 decimal places on query side and this solved my issue.

Thanks for your help.

Roland