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

[Deku · Accepted solution]

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

[v-ssriganesh]

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]

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 · Accepted solution]

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 · Accepted solution]

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.