cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Report builder - Unable to render paginated report error

Hi There, 

 

I created a paginated report in Power Bi Report Builder. In the desktop application, the report runs without any errors. I am using a Microsoft SQL server management studio database. All gateways are set up and running. 

I published the report to the Power Bi Service but now I get the below error when trying to run the report:

 

Annemie19_0-1605031272138.png

 

Does anyone know how to resolve this?

 

Kind Regards, 

Annemie

3 REPLIES 3
Community Support
Community Support

Hi @Annemie19,

SSMS is a management tool that can be used to connect to SQL server DB or SQL server analysis service DB. What type of data source are you test? Connection mode?

BTW, your error message seems like relate to data source connections.  Can you please share more detailed information to help us clarify these?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi Xiaoxin, 

 

I am connecting to a SQL server DB, please see connection details below:

Annemie19_1-1605247604490.png

 

 

Kind Regards, 

Annemie

Hi @Annemie19,

Which version of the report builder client are you test? Any firewall rule or policy changes on your device? Did these connection string work well when you test with other connection tools on the same device? (please test both ip/port and server name, sometimes one of these methods does not work on specific devices)

I'd like to suggest you share more detailed information to help us confirm if this issue related to a specific device or client version.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors