
Limitless Analytics with Azure Synapse
By :

Before we can start creating our Power BI reports, we need to create our datasets to visualize the data through Power BI reports. So, we will divide this section into two subsections. First, we will learn how to create a new Power BI dataset in Azure Synapse and then we will learn how to create a Power BI report.
We need to add a Power BI dataset from a data source and publish it to Power BI to build reports in Azure Synapse Studio. We can add the dataset directly to the Power BI service or we can add a dataset to the Power BI Desktop version and then publish it to the Power BI service.
The following section comprises the steps for adding data from a sample Excel file from a local machine as a new dataset to the Power BI service.
In order to add a new dataset to the Power BI service, sign in to https://powerbi.com and click on your workspace: