This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
Hi,
Correct me if i am wrong. But there are 2 sorts of Power BI: Power BI Desktop and Power BI services.
Is it possible to connect to a SQL Server database with Power BI services ?
Gr. Peter
Solved! Go to Solution.
HI @PeKi1972 ,
You are correct that there is Desktop and there is Service. They both connect to almost all the same connections. SQL is one that works in both.
The normal process is that you create your report with the visuals and data connections in Desktop and then you publish to the Service.
Once in the Service, you will need to have a gateway setup to get to the SQL server if it is internal to your organization and not cloud based. As a rule, you will want the gateway on a server of something that stays on most of the time and the gateway will be shared by numerous users through the data connections. This article explains the gateways.
On-premises data gateway - Power BI | Microsoft Learn
Proud to be a Datanaut!
Private message me for consulting or training needs.
HI @PeKi1972 ,
You are correct that there is Desktop and there is Service. They both connect to almost all the same connections. SQL is one that works in both.
The normal process is that you create your report with the visuals and data connections in Desktop and then you publish to the Service.
Once in the Service, you will need to have a gateway setup to get to the SQL server if it is internal to your organization and not cloud based. As a rule, you will want the gateway on a server of something that stays on most of the time and the gateway will be shared by numerous users through the data connections. This article explains the gateways.
On-premises data gateway - Power BI | Microsoft Learn
Proud to be a Datanaut!
Private message me for consulting or training needs.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 14 | |
| 10 | |
| 10 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 37 | |
| 32 | |
| 28 | |
| 22 | |
| 20 |