topic Re: Unable to connect to data source in Report Server

Unable to connect to data source

张青洛 — Tue, 03 Aug 2021 10:22:56 GMT

我是一个新用户，现在我已经创建了一个新的SQL服务器连接与电源BI桌面。发布后，我无法打开它。使用以前连接的 SQL 服务器，显示器发布后是正常的。在测试并重新启动数据网关后，仍无法使用。请帮助找出原因。谢谢！

Re: Unable to connect to data source

张青洛 — Tue, 03 Aug 2021 10:31:24 GMT

Re: Unable to connect to data source

张青洛 — Tue, 03 Aug 2021 23:52:04 GMT

I reset the gateway connection for this data set in the data set last night, but it still doesn't work. This morning, I just opened it without setting anything. I don't know where the problem is at present.

Re: Unable to connect to data source

Anonymous — Thu, 05 Aug 2021 05:11:40 GMT

张青洛

In the report server manager Database interface, you can change it to another RS database or create a new RS database. Once complete, you need to restart the server before accessing the web portal.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: Unable to connect to data source

张青洛 — Fri, 13 Aug 2021 08:36:34 GMT

I don't understand what you're talking about, and I've never seen this interface before, okay

Re: Unable to connect to data source

Anonymous — Fri, 13 Aug 2021 09:01:53 GMT

张青洛

My apologize, I thought this is a report server question. Seems you are using Power BI Service not Power BI Report Server.

This is Power BI Report Server Forum, they are 2 different services. We also have other forums: Get Help with Power BI - Microsoft Power BI Community

Glad you were able to open the report successfully. For new database in Power BI Service, should be fine if you correctly added the new datasource connection in manage gateways,

Best Regards
Paul

Re: Unable to connect to data source

张青洛 — Fri, 13 Aug 2021 09:04:38 GMT

I have encountered this problem again and I am trying to deal with it