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 as a reference to the other).
Now I want to set the incremental refresh, so:
As the final step I go the original table and I enable de incremental refresh setting to load the full data of the last 10 years and to reload only the last 3 months.
I tried to set the incremental refresh on the table set by reference but I can't because power bi desktop says I must filter the table using the parameters (which in theory is done as it's a table by reference).
When I publish to the web and do a full reload the original table works as expected. It is loading the full data and subsequent refreshes only reloads the last two months.
But the table copied by reference is only showing the last two months all the time.
¿Any ideas on how to fix this?
I am facing the same issue. Did anyone fine a solution?
I have incremental refresh set on a table. This table is referenced twice in the mquery. When the dataset is deployed and I run the refresh, the master table is refreshed, but the two tables referencing it do not.
Holy cow, I am dealing with the same problem and thought I'm alone with it
I also opened a thread about that
Furthermore, I set a ticket at Microsoft and we are trying to fix that.. as soon as I got an answer, I will post it here
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.
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.
@Anonymous it is really interesting question. I think I know the answer but have to find out best way to explain this. I will try to reproduce this on my end and then come up with an answer, it might take a while thou 🙂
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!