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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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