cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors