Forum Discussion

AndyR123's avatar
AndyR123
Icon for Helper I rankHelper I
6 years ago
Solved

Connect Power BI Service to local SQl Server

Hi,   i want to offer an app, which needs to select some data like currency, geo data etc from a local SQL Server (no gateway). So is it possible to promote a SQL Server, so that Power BI Service ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi AndyR123 

     

    It doesn't support to directly connect to SQL Server database in Power BI Service, we need to first connect to SQL database in Power BI Desktop, create reports there and publish report to Power BI Service. However, it is possible to connect directly to SQL Server Analysis Services  databases in Power BI Service.

    You can review the following article about data sources in Power BI Service.

    https://docs.microsoft.com/en-us/power-bi/service-get-data

     

     

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi AndyR123 

 

It doesn't support to directly connect to SQL Server database in Power BI Service, we need to first connect to SQL database in Power BI Desktop, create reports there and publish report to Power BI Service. However, it is possible to connect directly to SQL Server Analysis Services  databases in Power BI Service.

You can review the following article about data sources in Power BI Service.

https://docs.microsoft.com/en-us/power-bi/service-get-data