PowerBI + Synapse Performance test

1. In Synapse Studio, go to Develop > Power BI.
2. Go to NYCTaxiWorkspace1 > Power BI datasets and select New Power BI dataset. Click Start.
3. Select the SQLPOOL1 data source, click Continue.
4. Click Download to download the .pbids file for your NYCTaxiWorkspace1SQLPOOL1.pbids file. Click Continue.
5. Open the downloaded .pbids file. Power BI Desktop opens and automatically connects to SQLDB1 in your Azure Synapse workspace.
6. If you see a dialog box appear called SQL Server database:
   1. Select Microsoft account.
   2. Select Sign in and sign in to your account.
   3. Select Connect.
7. After the Navigator dialog box opens, check the PassengerCountStats table and select Load.
8. After the Connection settings dialog box appears, select DirectQuery > OK.
9. Select the Report button on the left side.
10. Under Visualizations, click to the line chart icon to add a Line chart to your report.
    1. Under Fields, drag the PassengerCount column to Visualizations > Axis.
    2. Drag the SumTripDistance and AvgTripDistance columns to Visualizations > Values.
11. On the Home tab, select Publish.
12. Select Save to save your changes.
13. Choose the file name PassengerAnalysis.pbix, and then select Save.
14. In the Publish to Power BI window, under Select a destination, choose your NYCTaxiWorkspace1, and then click Select.
15. Wait for publishing to finish.

For more details,please refer to:

https://docs.microsoft.com/en-us/azure/synapse-analytics/get-started-visualize-power-bi