Forum Discussion
Analyze in Excel
Hello Community, I have a Semantic Model in PBI. I used analyze in excel to integrate columns and measures into a table in Excel. I transformed the output table in power query in another ...
Thanks for your detailed reply, it was really helpful.
Regarding my setup, I have a table which is fed by my semantic model.
After adding the commentary column to this table, I duplicate the Query like you said and merge it by itself via my identifier.
But now both queries have the same source(my semantic model), is this correct?
Wouldnt a change in the rows affect the query which i use for the merge?
Thanks a lot!
My Table
as Cristian_Angyal says. Do not duplicate the query. Create a new query on the excel output table of the original query.