Need a help in SSRS Paginated Report

Anonymous — Wed, 04 Dec 2024 16:20:23 GMT

Hey guys,
To integrate with Azure Synapse Analytics in Paginated report builder.
How can I connect? Could anyone of you help me with this?

Re: Need a help in SSRS Paginated Report

Anonymous — Thu, 05 Dec 2024 02:16:06 GMT

Hi, Anonymous

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:

Create embedded data sources for paginated reports in the Power BI service - Power BI | Microsoft Learn

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.

topic Re: Need a help in SSRS Paginated Report in Report Server

Need a help in SSRS Paginated Report

Re: Need a help in SSRS Paginated Report