Adding new power query programatically

[jaryszek]

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:

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

[v-ssriganesh]

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]

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

Docs here

[jaryszek]

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 :

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]

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

[jaryszek]

Thank you, 

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

Best,
Jacek

[Deku]

Yes

[jaryszek]

hmm thank you. 
I need to test it more. 

[v-ssriganesh]

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.