I am trying to setup a dataflow that connects to an on-premise SQL database via the powerbi gateway. When congifuring the dataflow, the power query preview does bring through the data from the table ...
Update:
Microsoft is on the case with this one. we did progress this by allowing the azure endpoints on our proxy. the error I am now experiencing is:
Error: AzureDataLakeStorage failed to get the response: 'Unable to connect to the remote server'
I will post an update once resolved