Power BI performance accelerator for Azure Synapse Analytics

Question

When Azure Synapse Analytics was announced,
one very interesting feature announced was the "Power BI performance accelerator for Azure Synapse Analytics".
https://powerbi.microsoft.com/en-us/blog/building-systems-of-insights-at-enterprise-scale-with-power-bi-and-azure/
Now, since these days we cannot find any update about that feature on Azure Updates and it is also not present in the Power BI release wave documentation.
So is there any update about that feature? Will it be present in the next release wave?

Answer 1

Hello @Enrico Pirazzini ,

Welcome to the Microsoft Q&A platform.

Currently this feature is not yet available in Azure Synapse Analytics.

While waiting for this feature to be GA with PBI service, I believe you can get the similar behavior by directly running below command and a SQL statement in Azure Synapse SQL UI or SQL Mgmt studio. This will produce XML output, with recommended MTV, if that make sense to the engine based on your SQL statement.

EXPLAIN WITH_RECOMMENDATIONS <SQL_statement>

We will share and elevate your feedback with the Azure Synapse Analytics product team.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators