Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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:
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
Solved! Go to Solution.
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.
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.
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.
User | Count |
---|---|
45 | |
26 | |
21 | |
18 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |