In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will build a Power BI model over that view and generate visual reports on the data.
Steps for generating Power BI reports from the views
First, we need a database and view. I go to the Develop tab in Synapse Studio and create a new SQL script