ssrs to power bi multiple data asources

[powerbiexpert22]

how to migrate ssrs reports pointing to multiple data sources to power bi paginated reports?  below are the source systems

• NAV 2013 R2
• SharePoint 2013
• SQL database resides in the TARGIT server
• SQL database resides in the SharePoint database server

ssrs reports are connected live with sharepoint

[tharunkumarRTK · Accepted solution]

@powerbiexpert22 

AFAIK, Paginated report builder does not have sharepoint connector.
Supported data sources for Power BI paginated reports - Power BI | Microsoft Learn
You can create a Power BI dataset (semantic model) with sharepoint as a data source and publish it to Power BI service and use the semantic model as a datasource in your paginated report.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Nithinr · Accepted solution]

Get the assessment done first to determine supported and unsupported features. this will help in migrating reports in bulk. Below link provides detail process

Plan to migrate .rdl reports to Power BI - Power BI | Microsoft Learn

[tharunkumarRTK · Accepted solution]

@powerbiexpert22 

AFAIK, Paginated report builder does not have sharepoint connector.
Supported data sources for Power BI paginated reports - Power BI | Microsoft Learn
You can create a Power BI dataset (semantic model) with sharepoint as a data source and publish it to Power BI service and use the semantic model as a datasource in your paginated report.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun