Hi, @aditya0125
Open Report Builder, and in the Report Data pane, right-click Data Sources and select Add Data Source. Next, select Azure Synapse Analytics from the list of connection types.
You can enter the connection string directly, or use the Build button to open the connection properties dialog.
Fill in the necessary fields such as server name, database name, and authentication method (Basic, SSO, or OAuth2).
Once you've entered the connection details, click Test Connection to make sure the data source is configured correctly.
Specify the credentials to use for this data source. You can choose to use Windows authentication, SQL Server authentication, or other supported methods.
Once the data source is set up, you can create a dataset by right-clicking Datasets in the Report Data pane and selecting Add Dataset. Use the query designer to build queries from Azure Synapse Analytics data sources.
You can check the following link:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @aditya0125
Open Report Builder, and in the Report Data pane, right-click Data Sources and select Add Data Source. Next, select Azure Synapse Analytics from the list of connection types.
You can enter the connection string directly, or use the Build button to open the connection properties dialog.
Fill in the necessary fields such as server name, database name, and authentication method (Basic, SSO, or OAuth2).
Once you've entered the connection details, click Test Connection to make sure the data source is configured correctly.
Specify the credentials to use for this data source. You can choose to use Windows authentication, SQL Server authentication, or other supported methods.
Once the data source is set up, you can create a dataset by right-clicking Datasets in the Report Data pane and selecting Add Dataset. Use the query designer to build queries from Azure Synapse Analytics data sources.
You can check the following link:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
