Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power Query, Reference tables, Refresh

Hello
So, I need your help.
I have a problem with refreshing tables.
I have a table - call "mainTable", datasource is azure/databricks, have ca. 0,5mln rows.
(Steps : Source, Navigation)

 

I create by right click -> Reference, three reference tables Q1,Q2,Q3.

My goal is: during refresh my project only mainTable should downloaded datasource and the other 3 reference tables should be based on this mainTable.

Unfortunately when I refresh my project all 3 reference tables downloading the same datasource (3x 0,5mln)

 



I checked/uncheked this but still without good result.

 

 

I read that it is possible that after downloading the first table, the other caching and based on this first downloaded table. But i dont know how can I do it 😞

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      "I suppose you can try to reference from the source query table and cancel the 'include in refresh' option of the reference tables"

      its doesnt work.