Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Nextime
New Member

Connect SQL database to Power BI service

Good morning,

 

I have a problem.
I created a Power BI report on the Desktop version and I successfully imported my SQL database (to use the data) then I exported my report in Power BI Service (Web) and, in this version, I can't reconnect my SQL server.

 

When I try to connect my SQl server to Power BI Service, I get this error message: 

Nextime_0-1728390841827.png

I need to use the Web version of Power BI to automate the sending and updating of reports, I also need my SQL server because all my data is on it.

 

How to do it?

 

Thank you so much.
Evan

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

If your SQL Server database is on premise then you need to use an enterprise gateway. Otherwise the Power BI service has no way to get to your database.

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @Nextime ,

 

Agree with Ibendlin. With gateway installed, you need to manage it in Power BI Service, please kindly refer to

Manage a SQL Server data source - Power BI | Microsoft Learn

If the issue is resolved, please accept his reply as a solution.

If the issue is still not resolved, please provide more details.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

lbendlin
Super User
Super User

If your SQL Server database is on premise then you need to use an enterprise gateway. Otherwise the Power BI service has no way to get to your database.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.