Forum Discussion

naresh202's avatar
naresh202
Frequent Visitor
2 years ago

Can Power BI Dataflow have a Direct Query/Connection to data source like SQL server (on-premise)

Hi Everyone, Can we have a direct/live connection to source system (SQL server On-Premise) using Dataflow. Our Project requirement is, to get data into Power BI via Gateway for Reporting needs, so ...
Need Help
NandanHegde's avatar
NandanHegde
Super User
2 years ago

Based on my understanding, Power BI dataflow doesnt support direct query and only import mode.

Power BI dataset supports direct query to database.

Any reason why you need PowerBi dataflow to have direct query rather than dataset/semantic model?

naresh202's avatar
naresh202
Frequent Visitor
2 years ago

Thanks Nandan for the reply !!

The requirement is to have a connection to Datasource via DataGateway before we start Report development.

I can't see Power BI desktop having an option to Getdata via DataGateway.

 

Thanks,

Naresh

 

  • NandanHegde's avatar
    NandanHegde
    Super User
    2 years ago

    Power BI desktop is a server installation, so there is no need of gateway.

    gateway is a brdige between PowerBI service (Cloud) and your on prem server.

     

    So the only way is for you to create a dummy report and publish to service and test the gateway in connection settings.