topic Re: Adding new power query programatically in Developer

Adding new power query programatically

jaryszek — Fri, 21 Mar 2025 15:30:10 GMT

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

Re: Adding new power query programatically

Deku — Fri, 21 Mar 2025 17:42:04 GMT

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

Docs here

Re: Adding new power query programatically

jaryszek — Mon, 24 Mar 2025 08:50:27 GMT

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

Re: Adding new power query programatically

Deku — Mon, 24 Mar 2025 10:27:10 GMT

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

Re: Adding new power query programatically

jaryszek — Mon, 24 Mar 2025 10:54:12 GMT

Thank you,

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

Best,
Jacek

Re: Adding new power query programatically

Deku — Mon, 24 Mar 2025 10:56:51 GMT

Yes

Re: Adding new power query programatically

jaryszek — Mon, 24 Mar 2025 10:57:46 GMT

hmm thank you.
I need to test it more.

Re: Adding new power query programatically

v-ssriganesh — Tue, 06 May 2025 06:31:02 GMT

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.

Re: Adding new power query programatically

v-ssriganesh — Sat, 10 May 2025 18:09:32 GMT

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.

Re: Adding new power query programatically

v-ssriganesh — Tue, 13 May 2025 05:20:37 GMT

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.