Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Query folding from Power Platform Datflows not working properly

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)

Status: Needs Info
Comments
cmeu
Advocate III

Forgot to mention, this is also impacting the power platform dataflow connector used in Excel's version of Power Query - so I don't believe it to be specific to the Power BI Desktop App. 

Anonymous
Not applicable

Hi @cmeu 

Is there an error message associated with it ?

 

Best Regards,
Community Support Team _ Ailsa Tao

cmeu
Advocate III

Thanks @Anonymous 
No there are no errors. The only indication is the heavily degraded performance.
When running an diagnostic on the steps, it does throw a line which states:

    HandlersQuery: ReportFoldingFailure