Forum Discussion
Power BI Developer PC not on Domain with Gateway and SSAS, is it possible?
Hi MarioTechera
No. Power BI Service On‑premises data gateway SSAS Tabular (Live connection) is not supported on a standalone / non‑domain machine.
Although you can technically install SQL Server, SSAS Tabular, and the on‑premises data gateway on the same standalone PC, Live Connect from the Power BI Service will not work in this setup.Live connections to SSAS Tabular require Windows Authentication and Kerberos delegation so that the Power BI Service can impersonate the end user. This only works in an Active Directory domain environment. A workgroup (non‑domain) machine has:
- No Active Directory
- No Kerberos
- No SPNs
- No delegation
As a result:
- Power BI Desktop may work locally
- The gateway may show Online
- But Power BI Service Live Connect will fail with authentication / impersonation errors
(this is by design, not a misconfiguration)
Reference : Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn
Configure Kerberos-Based SSO from Power BI Service to On-Premises Data Sources - Power BI | Microsoft Learn
Configure Analysis Services for Kerberos constrained delegation | Microsoft Learn
Hope this helps !!Thank You.
Hi v-aatheeque ,
my question has not been answered yet:
Is it possible to install the data gateway, SSAS and SQL Server on the same standalone PC without being on a domain so that the Power BI service can access a tabular cube using Live Connect?
I haven't been able to get it to work.
If someone has any idea I would be very greatful.
Regards!
Community SupportHi MarioTechera
No. Power BI Service On‑premises data gateway SSAS Tabular (Live connection) is not supported on a standalone / non‑domain machine.
Although you can technically install SQL Server, SSAS Tabular, and the on‑premises data gateway on the same standalone PC, Live Connect from the Power BI Service will not work in this setup.
Live connections to SSAS Tabular require Windows Authentication and Kerberos delegation so that the Power BI Service can impersonate the end user. This only works in an Active Directory domain environment. A workgroup (non‑domain) machine has:
- No Active Directory
- No Kerberos
- No SPNs
- No delegation
As a result:
- Power BI Desktop may work locally
- The gateway may show Online
- But Power BI Service Live Connect will fail with authentication / impersonation errors
(this is by design, not a misconfiguration)
Reference : Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn
Configure Kerberos-Based SSO from Power BI Service to On-Premises Data Sources - Power BI | Microsoft Learn
Configure Analysis Services for Kerberos constrained delegation | Microsoft Learn
Hope this helps !!
Thank You.