Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
19 | |
4 | |
3 | |
1 | |
1 |