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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
nr63bi
Helper I
Helper I

Copy a table but not refresh the source

Hello,

 

Is this possible to create a table (Table 2) that copy another table which has a source  (Table 1). And then create a Table 3 that is a transformation of Table 2. 

 

And in Power BI Desktop, when I refresh Table 3, Table 2 is updating but not Table 1. I want refresh only Table 2. 

 

Basically, I just want to use Table 2 (where i do all the transformations that i want) only as a copy of Table 1 and then forget Table 1. 

 

Do you know how it is possible ? 

 

Thank you in advance

1 REPLY 1
Anonymous
Not applicable

If you want to keep that first table immutable forever, turn it into a table of record values. But if you are looking for an answer to the age old question, "Can I set my source table to not refresh once the data is imported, so that the data doesn't keep refreshing from the source every time I add a new step?", then the answer is "no".

 

--Nate

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors