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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.