Incremental Refresh Reference Table

[PowerBI123456]

Hi,

I am setting up incremental refresh in data flows. I have a table coming from SQL and then referencing that table in another table. Do I need to set up Incremental refresh on both or only the original table?

Also, if I wanted to disable the load for the original table, can I set up incremental table only on the reference table? Will it still work? 

Thanks!

[Anonymous · Accepted solution]

Hi @PowerBI123456 

I think you connect to SQL in dataflow, upload Table1 from SQL and then build a new table(Table2) refer from Table1.

Now your problem is that whether you need to set Incremental Refresh for Table1 or Table2.

We need to set Incremental Refresh for both Table1 and Table2.

When you refresh in dataflow, your Power BI service will send queries to the data source.

We can see in my SQL Sever Profiler, when I refresh this dataflow, it will send two queries to the data source.

It means Table1 and Table2 all will send independent queries to data source.

So we need to set Incremental Refresh for both Table1 and Table2.

If you want to disable the load for the original table, you can set up incremental refresh only on the reference table. It will still work.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.