Forum Discussion
On Premise Gateway / SQL Server DataFlow
I'm connecting to an on premise gateway on a remote server. In Manage Gateways, connection succeeds. I want to create a dataflow from the sql server. When I try to connect, Power BI throws an "...
Hi jhcannon
Can you provide the screenshots of dataflow configuration and the datasource configuration ?
As you said, when you configure the datasource in Manage gateways, it shows that the connection is successful, then the SQL server and credentials should be correct . Perhaps you can create a dataset whose data source is SQL, and then check whether the refresh is successful in Service, to determine whether it is a SQL problem ?
Best Regard
Community Support Team _ Ailsa Tao