cancel
Showing results for 
Search instead for 
Did you mean: 

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

Hi @cmeu 

Is there an error message associated with it ?

 

Best Regards,
Community Support Team _ Ailsa Tao

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. 

v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @cmeu 

Is there an error message associated with it ?

 

Best Regards,
Community Support Team _ Ailsa Tao

cmeu
Advocate III

Thanks @v-yetao1-msft 
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