Forum Discussion
Helper Iwhen using #sections powerbi gives empty table
Hi Aklys
Here is the description of the #sections:
#section only works in the compile environment, and when you leave Power Query, it means that it is out of the running state, so it returns a null value.
M Language Sections - PowerQuery M | Microsoft Learn
Instead of relying on #sections, try to use named queries directly. This can bypass the issues caused by the different processing stages in Power BI.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IUnfortunately I want to reference existing query results dynamically but that creates an issue with the privacy firewall when the source of the dynamic references is from a CSV. It doesn't seem to like combining the data inside powerquery without utilising #sections.
I guess that PowerQuery can only do dynamic referencing in it's editor but breaks when you leave that environment. Thanks for clarifying the ephemeral nature of #sections