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
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
Fabcon_Europe_Social_Bogo

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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