SSRS to Paginated (Multiple datasources)

[powerbiexpert22]

• i need to convert some ssrs report to paginated report
• exitsing ssrs reports are created using combination of below source systems
• ssrs reports shows near real time data (5-10 minutes)
• paginated reports should display near real time data (5-10 minutes)

Source Systems

1. NAV 2013 R2
2. SharePoint 2013
3. SQL database resides in the TARGIT server
4. SQL database resides in the SharePoint database server

[GilbertQ · Accepted solution]

Hi @powerbiexpert22 

Here is a list of the supported data sources. As you can see below there is an ODBC option which should allow you to connect to any data source.

Supported data sources for Power BI paginated reports - Power BI | Microsoft Learn

[v-tianyich-msft · Accepted solution]

Hi @powerbiexpert22 ,

Following @GilbertQ  advice, you can also continue to refer to the following link:

What are paginated reports in Power BI? - Power BI | Microsoft Learn

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

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi @powerbiexpert22 

Here is a list of the supported data sources. As you can see below there is an ODBC option which should allow you to connect to any data source.

Supported data sources for Power BI paginated reports - Power BI | Microsoft Learn