Forum Discussion
Dynamic combine tables from existing tables with table(Query) name
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.
As there is no solution I think we can close the post. thank you for the support.
Ok. I'll mark mine as the "solution" for now as it is since it isn't a bug and a design issue, but if Imke comes in with some Magic M code, we can change that.