Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

incremental refresh on table by reference

Hi, in my data model I pull a table from sql server and then after some transformations on power query I copy this table by reference. So I have two tables with the same data (only that one is set a...
Need Help
DouglasBrito's avatar
DouglasBrito
Helper I
6 years ago

Hi there,

 

I have the exactly same need, my main table A (thats pull data from SQL Server) is being referenced 2x times (by tables B and C), but once I set the incremental refresh on table A the dependent tables, B and C, have just records associated to filter range defined on PBI desktop. Seems that I have to setup the incremental on tables B and C also, but as these tables are grouping data they do not have the date column as date/time. Seems that PBI will have to pull data, from SQL, 3 times instead of just one. Wondering if this will be effective.

 

 

 

vissvess's avatar
vissvess
Helper V
6 years ago

I have the same case but additional complexity. I actually have the Main table A disabled load.
Only referenced table B & C are only loaded but not able to set incremental refresh as both will not have the parameters set.

 

Expertise support needed.