Synapse Serverless SQL & Power BI — Having Fun With PIVOT!
Check how the latest improvements to Synapse Serverless SQL pool can help you create one of the most popular Power BI transformations in a more optimal way!
Despite my planning not to write any “serious” blog posts till the end of the year (I just wanted to create some entertaining stuff), a recent announcement from Microsoft that Serverless SQL Pool within Synapse now supports a whole new set of T-SQL functions forced me to change my initial plans and play around with the latest stuff.
Honestly, I was curious to test how PIVOT works in the synergy between Power BI and Synapse, as this is one of the most used transformations in Power BI.
Before you proceed reading, maybe you would like to check the article where I explained what is Synapse Analytics, and what kind of benefits it brings to a Power BI table.
In case you are interested how much will using the Serverless SQL pool within Synapse cost you, please refer to this article and check all the different scenarios.
Scenario
As in the previous examples, I will use the NYC Taxi dataset to prepare different use-cases, which means that I wanted to check how PIVOT…
