[SSAS]PBI report live connect to SSAS with On Promise Gateway - moxuemeivip/Microsoft-Analysis-Service-Or-Fabric GitHub Wiki

PBI AAD account:[email protected] with Fabric Pro license

SSAS instance and Power BI On Promise Gateway running on machines as Domain member to Domain xuemeimo1.lab

SSAS named instance: AS\LULUSSAS, Database name:Adventure Works Internet Sales

SSAS admin user account:XUEMEIMO1\SSASAdmin, and effectiveusername=[email protected]

Firewall rule to allow inbound request for SSAS machine: image

PBI Desktop run As XUEMEIMO1\SSASAdmin, and sign in with windows authentication type to SSAS: image

image

image

image

Create On Promise Gateway data source connection with windows User account XUEMEIMO1\SSASAdmin: image

Add an EffectiveUserName mapping rule by replacing M365x68797834.onmicrosoft.com with xuemeimo1.lab.

image

Example for testing with a UPN mapping:

it will send a web request /v2.0/myorg/me/gatewayClusterDatasourcesMapUpn

image

Update the PBI semantical model settings with the OPGW data source connection object just created above.

image

Query request handle details(open connection) from gateway logs:

image

PBI Visual render success from service side: image