Forum Discussion
Enterprise Gateway Connection to SQL Server Says Connected yet Fails
Created enterprise gateway on my server in cloud that has my SQL server on it. I access SQL SSMS remote as I have remote access turned on that server. PBI desktop report connects to this data s...
GilbertQ
Super User
Super UserHi Karljr
What happens when you go into the dataset settings, can you confirm that the data source is connected to the data source?
Here are more details on how to connect to the data source: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Docs
I looked at that yesterday and thought it was good. But now questioning that it is saying in a strange way they do not work. Says admin has granted access yet above it acts maybe like not valid. I use those same creds to sign into SSMS remote into that sql server and database.
Is that what the yellow highlights are telling me?