This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Given the below PQ, in a Premium capacity, with enhanced compute engine turned "On" - folding fails:
// ims_activities_proposed
let
Source = PowerPlatform.Dataflows(),
Workspaces = Source{[Id="Workspaces"]}[Data],
#"00000000-0000-0000-0000-6a40bfcc9cdf" = Workspaces{[workspaceId="00000000-0000-0000-0000-6a40bfcc9cdf"]}[Data],
#"00000000-0000-0000-b796-70648ff38dc8" = #"00000000-0000-0000-0000-6a40bfcc9cdf"{[dataflowId="00000000-0000-0000-b796-70648ff38dc8"]}[Data],
ims_activities_proposed_ = #"00000000-0000-0000-b796-70648ff38dc8"{[entity="ims_activities_proposed",version=""]}[Data],
#"Filtered Rows" = Table.SelectRows(ims_activities_proposed_, each [regarding] = "ABC002113301")
in
#"Filtered Rows"
The desktop client retreives Gigabytes of data, to filter down to < 10 rows.
I don't know for sure that it is related, because it lasted for a while, but this all started since the recent service degradation impacting power platform dataflows and query folding (Solved: Dataset refresh utilizing powerplatform.dataflows ... - Microsoft Fabric Community)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.