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 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 ?
Hi @amchitchandakit still the same problem.I created a new Query (call Query1) and put it:=Table.Distinct(mainTable)
The new table is created.
But when I refresh my project both tables downloading data source.
@Anonymous , You might have done that duplicate or using the option add as new query.
In place of that you should create it using table function
Source = Table.Distinct(Table1)
Check power query table function:https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq
Or create in DAX using summarize or distinct
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.