Data Access Error when accessing PBI report on PBI Service.

[maynkk]

Hi, I have developed a PBI report using analysis services tbaular model as data source. I have connected to the model through Connect Live. When I published the report on PBI Services, while accessing the report it is giving data access error.
On-premise enterprise gateway is present. I have provided windows credential for Authentication. When I checked the connection with data source, it showed online.

I checked SQL Profiler, it showed following error:
"The following system error occurred: We can't sign you in with this credential because your domain isn't available. Make sure your device is connected to your organization's network and try again. If you previously signed in on this device with another credential, you can sign in with that credential."

Data source as well as gateway is installed on same system.

Please help me!!

[v-zhangti · Accepted solution]

Hi, @maynkk 

If this report makes use of a live Analysis Services connection, you could encounter an issue with a value being passed to EffectiveUserName that either isn't valid or doesn't have permissions on the Analysis Services machine. Typically, an authentication issue is due to the fact that the value being passed for EffectiveUserName doesn't match a local user principal name (UPN).

To confirm the effective username, follow this: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot#error-data-sou... 

If your Azure Active Directory UPN doesn't match your local Active Directory UPN, you can use the Map user names feature to replace it with a valid value. Or, you can work with either your Power BI admin or local Active Directory admin to get your UPN changed.

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn

Solved: PBI Gateway > SSAS: "The Following system error oc... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.