Forum Discussion

bheepatel's avatar
bheepatel
Resolver IV
6 years ago
Solved

Cannot connect to SQL Server in Dataflow

Good day,   I am creating a Dataflow in which I have chosen a "Blank Query" connection. In this "Blank Query" I copied and pasted a query I had built in PBI Desktop. This query uses a SQL Server co...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi bheepatel 

     

    If you are connecting to SQL server on-prem then you will need to install enterprise data gateway on this server in order for the service to be able to access, if you are using Azure SQL database or azure data warehouse instances then just use the relevant connectors and no gateway is required

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi bheepatel ,

In power bi service, if you want to connect to datasource on premiss, you should configure a gateway actually first. If just use the instance. you can use the connector as Mariusz  previously said.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.