publicly available data

Hi trindadsth​,

I suspect the load may actually be fine and you’re just seeing a limited preview of the table.

If you’re checking the data from the Warehouse explorer or a generated TOP query, that does not show the full row count. For example, Fabric has a Select TOP 100 rows option in the Explorer, and the Data preview is also intended only as a sample of the table.

I’d run a count directly against the two tables instead:

SELECT COUNT(*) AS CityRows FROM dbo.dimension_city;  SELECT COUNT(*) AS SaleRows FROM dbo.fact_sale;

If those counts return the expected larger numbers, then nothing is wrong with the COPY INTO operation. You were just looking at a preview/query that limits the number of rows displayed.

If the counts themselves really are only 10 and 100, then I’d check the exact COPY INTO statements and the Messages output from the load, because COPY INTO from those Parquet files should not normally stop after an arbitrary number of rows.

I’d start with the COUNT(*) though, since that will tell you straight away whether this is a loading problem or just what the Fabric UI is displaying.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.