The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
I was trying to check if "query folding" is hapening using "value.metadata" function. But I did not get any result (Expression.Error: The field 'QueryFolding' of the record wasn't found) when I tried this in original pbix file. But when I tried to recreate the same transformations in a new file, I could see the query folding details as shown in second screenshot. Could anyone help me understand why "value.metadata" does not return any value in some scenarioes?
Thanks in advance,
QueryFolding metadata is something the preview UI adds to a query to give it an indicator of when folding fails. In some cases this gets skipped as it isn't a step as far as the UI sees it.
Relying on this metadata is not supported, along with the undocumented function that it uses to determine this, Value.ResourceExpression, and doing so at your own risk.