Forum Discussion

tylerhahn3's avatar
tylerhahn3
New Member
9 years ago
Solved

On-Premesis SQL Server Gateway - How to add data source

Hi everyone:   I've succesfully installed the On-Premesis gateway for Power BI, flow, apps, etc... and connected it succesfully to my on-premesis sql server 2012 database. However I cannot for the ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi tylerhahn3,

     

    From your description, it seems that you connect to on-premise SQL Server database in desktop use DirectQuery mode, right?

     

    As you already installed the on-premise data gateway, you can go to Power BI service click Manage Gateways, create a SQL Server data source use the same connection information as in desktop. After publish the report to service, the dataset will be configured to use data gateway. For detail steps, see: Manage your data source - SQL Server.

     

     

    Best Regards,

    Qiuyun Yu

tylerhahn3's avatar
tylerhahn3
New Member
9 years ago

Ok, so I feel a bit stupid - but I was trying to use the web interface for Power BI to create a new dataset - which doesn't apparently have a directquery option to connect to an on premesis gateway. I just opened the desktop app, and ta-da, there is the option to use a sqlserver source. I'm not sure I understand the purpose of the gateway though, if I can't connect to my on premesis sql server to use directquery (or some other method of querying the connected database data source).

 

So I'd still love your help,

 

Tyler