Forum Discussion
Migration SSRS to POWERBI
Hi PowerBI Anonymous ,
Could you guide me the best approach for migrating SSRS reports to Power BI. All of my data sources are SQL Server on-premises. Additionally, could you guide me through the step-by-step process migrating SSRS reports to power Bi?
When I publish directly, I’m unable to see the semantic model.
Thanks
Hi Roomie117 ,
When you are deploying paginated reports through GitHub, the process works a bit differently from publishing directly in the Power BI Service. Publishing from Report Builder is fine for quick, manual work, but in a Dev environment where you want repeatable deployments, GitHub becomes the source of truth.
The RDL files stored in your repository should be the versions that move through your environments, and your GitHub workflow can publish those reports to the workspace using Power BI’s APIs or PowerShell modules. The one thing GitHub cannot do is create data sources in the Service, so those need to be set up manually in the workspace ahead of time, along with the gateway connection for your on-prem SQL Server. Once the data source exists, your pipeline can publish the RDL and rebind it automatically.
This way, you keep a clean CI and Dev process while still supporting manual publishing if you ever need it, but GitHub should be considered the main deployment path when you're managing environments.
Best Regards,
Tejaswi.
Community Support
11 Replies
hi Roomie117
please check this short blog for migration steps :
SSRS → Power BI: Practical Migration steps
Analytic Pulse Blog
Docynx Productivity Tools
Tool to Generate Realistic Sample Data Instantly onlineI am using GitHub for deployments from local to Dev. How should this be handled, considering that we can publish reports directly to the Power BI Service?
Roomie117
do you have deployment pipiline for dev to QA and QA to prod?
if yes then its sorted already, if not then create a pipeline.
Hey Roomie117 ,
I am assuming you are using the Power BI Report Builder to publish the SSRS reports as Power BI paginated reports.
In that case, the paginated reports do not have semantic model like the regular reports authored in Power BI Desktop do. You can simply edit the connection settings of the Paginated report itself (click on the three dots beside it > Manage) and update it accordingly.
Hope it helps!I am using GitHub for deployments from local to Dev. How should this be handled, considering that we can publish reports directly to the Power BI Service?
Roomie117 , I am assuming you are using Github actions for the deployment and using either FabricPS module or the older PowerBIMgmt module. In either of them, you should be able to deploy rdl files to the service.
As for datasource connection creation, you need to create the connections in Power BI service and this cannot be created programmatically yet. You should be able to bind the report to the appropriate connection programmatically.
Hope it helps!
