Forum Discussion

PaolaFarias's avatar
PaolaFarias
Frequent Visitor
8 years ago
Solved

Connect SQL Server on Power BI Online

Hi everyone!   I'm having trouble to understand how the data source from Power BI Online works.   I downloaded the desktop version, on-premise data gateways, attached it to my account on power bi...
  • Anonymous's avatar
    Anonymous
    8 years ago

    PaolaFarias,

    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

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

PaolaFarias,

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

Regards,
Lydia