Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Does anyone know how to resolve this?
Kind Regards,
Annemie
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
Hi Xiaoxin,
I am connecting to a SQL server DB, please see connection details below:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.