Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
henrywinata
Regular Visitor

SSAS Tabular in Power BI Web

Hi There,

 

I am using Power Bi Desktop right now using connection to SSAS Tabular on premesis. 

And When I Publish to Power Bi Web I always get Error about Gateway.

 

Can we use Power BI Web using SSAS Tabular connection?

 

Thanks

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

Hi henrywinata,

 

Based on your description, please check if you have configured user name mapping. For Analysis Services data sources, you should configure user name mapping if your Power BI service login names do not match your local directory UPN. To configure user name mapping, please follow steps below:
1. Go to the gear icon and select Manage Gateways.
2. Expand the gateway that contains the Analysis Services data source. Or, if you haven't created the Analysis Services data source, you can do that at this point.
3. Select the data source and then select the Users tab.
4. Select Map user names.
gateway-enterprise-map-user-names-effective-user-names.png
In Replace blank, input your power bi account name.
In With blank, input your local directory UPN.

 

Regards,
Jimmy Tao

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Hi henrywinata,

 

Based on your description, please check if you have configured user name mapping. For Analysis Services data sources, you should configure user name mapping if your Power BI service login names do not match your local directory UPN. To configure user name mapping, please follow steps below:
1. Go to the gear icon and select Manage Gateways.
2. Expand the gateway that contains the Analysis Services data source. Or, if you haven't created the Analysis Services data source, you can do that at this point.
3. Select the data source and then select the Users tab.
4. Select Map user names.
gateway-enterprise-map-user-names-effective-user-names.png
In Replace blank, input your power bi account name.
In With blank, input your local directory UPN.

 

Regards,
Jimmy Tao

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors