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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
thschr
Frequent Visitor

SQL Query Folding Massive Performance Decrease after PBI Update | PBI Service

Hello fellow Power BI enthusiasts,

 

since a few days we saw that there are some scheduled refreshes that suddenly take 6-7 hours instead of 30 minutes.

After quite some investigation, we were able to recreate the issue in PBI Desktop.

We had to download the newest version to be able to recreate it.

We use a Microsoft SQL Server and focus a lot on query folding.

What we see is that any step that causes query folding to break, takes many times longer than it used to.

A simple query like this which runs over a table containing 30 million rows takes 30 minutes to query.

A typical load time would be in the few-second range (we have a 2gig/s connection between our workstation and the SQL server).

 

"let
Source = Sql.Database("server", dbname),
Offers = Source{[Schema="dbo",Item="Offers"]}[Data],
#"Removed Other Columns1" = Table.SelectColumns(Offers,{"DataDate", "price", "Marketplace", "SKU"}),
#"Grouped Rows" = Table.Group(#"Removed Other Columns1", {"DataDate", "SKU"}, {{"Count", each _, type table [DataDate=nullable date, price=nullable number, Marketplace=nullable text, SKU=nullable text]}})
in
#"Grouped Rows""

 

We recreated the behaviour across various tables and always come to the same result. The moment we break query folding, performance on the new PBI 64bit version is super slow (also reflected in scheduled refreshs).

When we download the previous version, everything loads fine again.

 

Did anyone experience the same issue with the new version?

Any suggestions on things we could check?

3 REPLIES 3
MoorsTech
Advocate I
Advocate I

@Icey thanks, we are working on this issue with the support but have not yet found a resolution to this issue.

Icey
Community Support
Community Support

Hi @thschr ,

 

Since this can be reproduced and it may involve log or other sensitive information. It is suggested to create a support ticket to get futher help from Product Team.

 

In addition, if you get any information helpful from Product Team, could you share us?

 

Support Ticket.gif

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MoorsTech
Advocate I
Advocate I

Just pitching in to clarify:
This issue is perfectly reproducable and was clearly introduced with version 2.92.1067.0 (April 2021 QFE 2)
of Power BI Desktop, version 2.92.943.0 (April 2021 QFE 1) does not exhibit the same behavior.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors