Problem with reference table and refreshing

Question

Hello,I have a main table in my project (5mln rows)I created second table which based on main table (I add here a few steps).I&nbsp;thought, that when I refresh my project, then only main table downloading source and second table (reference) based on refreshed main table.But if I click refresh then both tables downloading source (2x5mln rows).Why ?&nbsp;

amitchandak · Answer

Anonymous , You might have done that duplicate or using the option add as new query.
&nbsp;
In place of that you should create it using table function
example
&nbsp;
Source = Table.Distinct(Table1)
&nbsp;
Check power query table function:https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq
&nbsp;
Or create in DAX using summarize or distinct

anonymous · Answer

Hi&nbsp;@amchitchandakit still the same problem.I created a new Query (call Query1) and put it:=Table.Distinct(mainTable)&nbsp;The new table is created.But when I refresh my project both tables downloading data source.&nbsp;&nbsp;

Forum Discussion

Problem with reference table and refreshing

2 Replies

Related content

Refresh problem

Power BI Report Server Scheduled Refresh Bottleneck Problem

Logic problem?

Incremental Refresh Problem

Dataflows refresh problem