Forum Discussion
Super UserAdding 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:
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
I just did this on one of my models. Made the changes on folder while desktop was closed. Openned successfully with the new table.
hmm thank you.
I need to test it more.
9 Replies
- 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.
v-ssriganeshCommunity 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.- 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.