Combining Power BI and aserverless SQL pool
Azure Synapse Studio gives you the flexibility to connect to the Power BI workspace and provides you with seamless integration between data sources and reports. You can work within the Synapse workspace to create Power BI reports independently in the Power BI service.
You have the flexibility to combine multiple data sources to create a single Power BI dataset. This helps you to analyze disparate data sources and create insight by referring to a single data model. We refer to this as a Power BI linked service.
Getting ready
We will be using the same Synapse workspace that we have used throughout the book for this recipe.
The prerequisites for this recipe are as follows:
- Make sure you have Power BI Desktop downloaded and installed. You can download it from this link: https://www.microsoft.com/en-in/download/details.aspx?id=58494.
- You need to have a Power BI Pro license to develop reports and get all the benefits of...