SSRS to Paginated Report : DataSource connections as per Customer Setup

[amaryad]

WWe have a product and We are using SSRS Report and Report Server for Our Clinents for Reports. We are using Shared DataSources in report, For Client Installation we have created Installer Script Which is Changing Reports DataSource <Tag> From <Dev> To <Prod> and also Shared DataSource Connection String and DB To Clients  Server and DB. 
While Migrating to PowerBI Embed ,How can We achive this. Using PowerBI Embed (App Owns Data Concept) I think we need to deploy the reports on PowerBI Service Portal and from there Using API call Report will be accesed using OnPremises Gateway, this is what i understood till now after going through the online info available.  I am still not able to undestand how can we attache DataSource of the Customer Report who is viewing report  OR Do we need to get seprate workspace and Power BI Liscense for Every Customer and Deploy Power BI Report on their Workspace. Or Can WE achive this like SSRS Reports using PowerBI Embed Liscense. 
Can we change datasource connection at the time of Installation.

[Anonymous · Accepted solution]

Hi,@amaryad .I am glad to help you.

Based on your description, you want to migrate your existing SSRS reports to Power BI embedded reports while maintaining customer-specific data source connectivity.
I think using Power BI Rest API is a good option for you.
Although I'm not very good at it, I want to help you and here are my suggestions.
1. Migrate to Power BI Embed (App Owns Data Concept): You need to deploy reports to Power BI Services and then use the local gateway to access the reports via an API call

You need to configure the data source in Power BI Services and make sure the local gateway has been set up correctly.
Configuring the gateway is very important, for refreshing the dynamic data source in Power BI service, you can refer to the following resolved issue.
URL:
Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric Community
Solved: Power BI Service with dynamic data sources - Microsoft Fabric Community
In Power BI, you can use Embed Token to configure different data source connections for different customers. This is similar to the way you use shared data sources in SSRS. You can dynamically change the data source connection string through API calls to accommodate different customers.
2. Do you need to create a separate workspace and Power BI license for each customer
I don't think you need to create a separate workspace for each customer as well as assign licenses separately.You can dynamically change the data source connection at report load time through the API. This way, you can manage all your customers' reports in a single workspace and dynamically change the data source connection strings according to your customers' needs.
We hope you find the following documentation helpful.
URL:
Plan to migrate .rdl reports to Power BI - Power BI | Microsoft Learn
Publish .rdl files to Power BI from Power BI Report Server and Reporting Services - Power BI | Micro...
What are REST APIs for Reporting Services? - SQL Server Reporting Services (SSRS) | Microsoft Learn

3.If you want to get to the DataSource of the customer report that is viewing the report, you can refer to the API link below:
URL:
Reports - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.