Forum Discussion
Dynamic combine tables from existing tables with table(Query) name
Hi Experts, Objective: I want to combine the existing tables in one tables with additional column as tables names in new table. I have 2 tables Table11 and Table22 with same data Column A,B,C...
This is not a bug Anonymous - it is a design issue. The service is specifically designed not to allow the #shared parameter that Power Query in Excel does. I don't know why, but it may be security or performance related or both.
You can read more about it here if you want the details -Automatically create function record for Expression.Evaluate in Power BI and Power Query – The BIccountant
I have tried the custom functin by ImkeF but it is returning null, so either I am doing something wrong (I give this a 99.9% chance of being issue here 😁) or this trick I do in Excel, which Imke showed me years ago on this very form, simply doesn't work in Power BI.
woring = Showing