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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jaryszek
Post Prodigy
Post Prodigy

Adding new power query programatically

Hello,

I want to add new query programatacilly using TMDL file.
What i did i have just copied existing query TMDL file, changed name and columns:

jaryszek_0-1742570844272.png

 

What I am afraid of is this  lineageTag: 34f209fc-367a-4b75-9861-db05a3c79d76.
I got the duplicated lineageTag error while opening bpip file. 

So what i did i have changed lineageTag: 34f209fc-367a-4b75-9861-db05a39999

and worked. 

 

But what it is? Do i need to provide it? How to be sure that this is unique ?

 

Best,

Jacek

 

2 ACCEPTED SOLUTIONS
Deku
Community Champion
Community Champion

I just did this on one of my models. Made the changes on folder while desktop was closed. Openned successfully with the new table.


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

hmm thank you. 
I need to test it more. 

View solution in original post

9 REPLIES 9
v-ssriganesh
Community Support
Community Support

Hi @jaryszek,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-ssriganesh
Community Support
Community Support

Hi @jaryszek,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Deku
Community Champion
Community Champion

You don't need to provide it, it will be generate for you. It is used for composite models

 

Docs here


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Thank you.

Exact steps which i did:

1) Created a copy from my current powery query in TMDL file. 

2) Changed the copy name

3) Removed Lineage tag for tmdl table using Visual Studio Code.

 

And i got :

jaryszek_0-1742806099069.png

 

jaryszek_1-1742806162149.png

I do not want to generate tmdl tables after saving pbip opened project.

I want to copy tmdl table with power query code with adjustments for table name, source and columns and open it after.

Best,
Jacek

 

Deku
Community Champion
Community Champion

I just did this on one of my models. Made the changes on folder while desktop was closed. Openned successfully with the new table.


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Thank you, 

did you remove Lineage tags from column names and for table ? 
And it worked? 

Best,
Jacek

Deku
Community Champion
Community Champion

Yes


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

hmm thank you. 
I need to test it more. 

Hi @jaryszek,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Deku for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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