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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
lsoohoo
Regular Visitor

Horizontal Fusion

Can anyone explain what the Desktop Preview feature "Horizontal Fusion" is? I can't seem to find any documentation anywhere.

lsoohoo_0-1663256113792.png

 

1 ACCEPTED SOLUTION
7 REPLIES 7
kingkaruna
Frequent Visitor

Why can't I see this preview feature anymore in Power BI desktop???

Clem_Fandango
Advocate II
Advocate II

This is a helpful video from Alberto at SQLBI.

Introducing horizontal fusion in DAX - YouTube

ML222
Frequent Visitor

Has anyone been able to test this?

I have tested some queries in DAX Studio while connected to a dataset with Horizontal Fusion disabled. Then enabled the feature, restarted Power BI, connected to the dataset and run the same query.

 

Time elasped is the same.

Number of queries sent off is the same.

Could be the queries I am running but just want to double check that someone has actually had success in testing this feature?


My dataset is connected via DirectQuery to SQL Server.

We have Premium P1 SKU - I haven't heard any feedback on improved performance either.

@ML222 I experience the same behaviour.

 

Situation

Power BI dataset with Direct Query connection to Snowflake Datawarehouse.

 

Test case

- Identified a testcase which sends out 13 queries to datasource

- Enabled the preview feature, saved the .pbix file.

- Closed Power BI desktop

- Re-opened the .pbix file

- Published the file to a PPU workspace.

- Ran a trace in DAX studio to capture the number of queries.

 

Outcome

The number of queries send to Snowflake was 13 before enabling Horizontal Fusion, and after enabling the number of queries was exactly the same.

Remo_
Advocate III
Advocate III

@lsoohoo 

Please check this latest anouncement by Microsoft:

https://powerbi.microsoft.com/nl-nl/blog/announcing-horizontal-fusion-a-query-performance-optimizati...

 

Horizontal fusion will decrease the number of queries send to the source system which will increase performance especially in Direct Query mode, but also in Import mode (however the gains shall be less visible).

Nart
Frequent Visitor

https://dax.tips/2019/10/16/pivoting-data-for-speed/

According to this article, it seems to be related to query optimisation

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors