I have a table that I pull via Power Query (from SQL Server).

Example columns:

Product id, Product name, product category, 
customer id, customer name, customer category, 
supplier id, supplier name, supplier category, 
region id, region name, sale date, sale tax, sale fee, sale amt.

Then, I create multiple dimension tables (customer; product; supplier; region) using DAX calculated tables from the above, and hide these columns from the main table, effectively making it a star schema.

I get the option to implement incremental load on the main table, but not on calculated tables. Is this unsupported?

If I do make incremental load on the main table, then will the calculated tables inherently get incremental load feature or will the calculated tables be rebuilt from scratch each time?

I have a table that I pull via Power Query (from SQL Server).

Example columns:

Product id, Product name, product category, 
customer id, customer name, customer category, 
supplier id, supplier name, supplier category, 
region id, region name, sale date, sale tax, sale fee, sale amt.

Then, I create multiple dimension tables (customer; product; supplier; region) using DAX calculated tables from the above, and hide these columns from the main table, effectively making it a star schema.

I get the option to implement incremental load on the main table, but not on calculated tables. Is this unsupported?

If I do make incremental load on the main table, then will the calculated tables inherently get incremental load feature or will the calculated tables be rebuilt from scratch each time?

• powerbi
• dax

1 Answer 1

"Incremental refresh" is acutally carried out by PQ via automated partition creation and management for semantic model tables. More specifically, as stated in MS official documentation. https://learn.microsoft/en-us/power-bi/connect-data/incremental-refresh-overview

... Table data is filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd.