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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.