Visualizing data using Power BI by connecting to serverless SQL pool

Power BI is an excellent data visualization tool and is often used to consume the processed data in Synapse. Power BI can connect to objects (views or external tables, for example) in serverless SQL pool. In this recipe, we will create a Power BI report that will connect to an external table defined in serverless SQL pool.

Getting ready

Create a Synapse Analytics workspace, as explained in the Provisioning an Azure Synapse Analytics workspace recipe of this chapter.

Create a Spark pool, as explained in the Provisioning and configuring Spark pools recipe of this chapter.

Create a lake database and Delta table, as explained in the Processing data using Spark pools and lake database recipe in this chapter.

Create an external table in serverless SQL pool, as described in the Querying the data in a lake database from serverless SQL pool recipe.

Download the latest version of Power BI Desktop from https...