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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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
Anonymous
Not applicable

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 @Anonymous 

Is there an error message associated with it ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable

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