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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.