Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 we want to know is Direct Query connection to source system SQL server (on-premise database) is possible from Dataflow and DataGateway.
If yes, please let me know how do we configure it.
Thanks,
Naresh
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?
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |