Horizontal Fusion

[lsoohoo]

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

[kingkaruna]

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

[Clem_Fandango]

This is a helpful video from Alberto at SQLBI.

Introducing horizontal fusion in DAX - YouTube

[ML222]

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.

[Anonymous]

@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.

[Anonymous]

@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]

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

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

[v-luwang-msft · Accepted solution]

Hi @lsoohoo ,

A picture to tell the details:

And refer:

https://medium.com/snowflake/power-bi-snowflake-performance-enhancements-with-horizontal-fusion-1cec... 

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

 Best Regards

Lucien