Forum Discussion
Unable to Connect to Data Source in Report Only
I am having an issue where a single report is throwing an error that its unable to connect to data source when opening the report in PBI Service only. It is a direct query SQL Server data source type...
GilbertQ
Super User
Super Userhi cusecuse315
Can you log into the gateway server and make sure that you can connect with the required credentials from the gateway server to your SQL Server?
Yes, I have used my personal work account, which is admin on gateway server and SQL Server, as well as the main service account for the gateway server and SQL Server. I also spun up a gateway on a different server and experienced the same issues.
Its very strange, I can refresh other reports using same connection type from other databases on the same server, but this database is failing, but only in service. Connection in Desktop is without issue. There are no security differences between various databases