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 ...
Hi there,
I got a similar problem - trying to connect to an IBM DB2 via Dataflow.
Gateway connection to Database ist established, I see preview Data but when I want to refresh I get an error message (different than the one jswift got):
Error: Program execution reached an invalid state. The execution should have never reached this code.
Has there been a solution yet v-robertq-msft ?
Best regards,
CP