Forum Discussion

Ledi's avatar
Ledi
Regular Visitor
1 year ago
Solved

Dataflow connection using power bi gateway

I am getting this connection error: "object reference not set to an instance of an object" when connecting to sql database on prem using power bi gateway in dataflow gen2   My user has the connecti...
  • Ledi's avatar
    1 year ago

    I tried the solution proposed above and it didn't resolve my issue. I was also testing the connection using get data in power bi report builder and that did eventually work but hit a blocker that power bi gateway connection is not supported yet. Couldn't get dataflow to connect at all but I believe I would ran into the same issue on tool limitation so we decided to design a rest api for the dataset and connect via web api so we could take advantage of the transformations offered by power bi which was always the goal.

    Thanks for all the response.