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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
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

  • shivamkapoor17's avatar
    shivamkapoor17
    New Member
    2 years ago

    Hi Qiuyun yu

    I am facing the same issue but with ssas live connection. I dont know what to put in username field and password field. Can you help me?