Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am having problems when I try to get data from an SQL server using Power BI embedded.
The scenario is the following:
I have implemented a MVC application that integrates PowerBI embedded. It works when I am getting data from a SQL Azure, but is not working when the data comes from a SQL Server. The error given is the following:
"Your data gateway (Power BI – personal) is offline, but a data gateway is available."
Is there any way to make it work?
Thanks in advance.
Solved! Go to Solution.
There is not gateway support for on-premise sql server database using PowerBi Embedded.
Power BI Embedded only support azure databases with direct connection and direct connection/scheduled refresh will not be supported for on-premises databases using gateway
I think PowerBI Embedded requires an on-premises gateway to be set up in order to connect to your own data source. Are you using that?
There is not gateway support for on-premise sql server database using PowerBi Embedded.
Power BI Embedded only support azure databases with direct connection and direct connection/scheduled refresh will not be supported for on-premises databases using gateway
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
4 | |
4 | |
4 | |
3 |