Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Problem with reference table and refreshing

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).

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 ? 

2 REPLIES 2
Anonymous
Not applicable

Hi @amchitchandak

it still the same problem.
I created a new Query (call Query1) and put it:
=Table.Distinct(mainTable)

pp92_0-1668002082237.png

 


The new table is created.

pp92_1-1668002099961.png


But when I refresh my project both tables downloading data source.

pp92_3-1668002316897.png

 

 

amitchandak
Super User
Super User

@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

example

 

Source = Table.Distinct(Table1)

 

Check power query table function:https://www.youtube.com/playlist?list=PLPaNVDMhUXGalVK1yOQ8hV2kWTNsZW5Gq

 

Or create in DAX using summarize or distinct

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.