cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 as a reference to the other).

 

Now I want to set the incremental refresh, so:

  1. I set the two parameters RangeStart and RangeEnd with type Datetime
  2. I insert a step to filter the original table so it filters the table between RangeStart (>=) and RangeEnd (<)

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?

6 REPLIES 6
halaseh
Frequent Visitor

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.

Verknuepfer
New Member

Holy cow, I am dealing with the same problem and thought I'm alone with it

 

I also opened a thread about that

https://community.powerbi.com/t5/Service/Reference-tables-data-not-refreshing-on-Service/m-p/1517156...

 

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

 

Regards

DouglasBrito
Helper I
Helper I

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.

 

 

 

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.

parry2k
Super User
Super User

@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 🙂






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Hi, it seems there's no answer to this. I can't find any info on the internet about this issue.

 

Have you find any solution to this?

 

Thanks!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors