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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
nithinab
New Member

Using Enterprise Data Gateway to connect Power BI report to Tabular Model (On Premise)

 

 

Issue:

The issue that we are facing is:

We understand that when creating a data source in Power BI to connect an on-premises Tabular Model, the account that is used to set up the data source should have 'Server Admin' rights on the Tabular Model.

From Microsoft:

" If the underlying error message is similar to the following, this means that the account you are using for the data source is not a server admin for that Analysis Services instance. Learn more

The 'CONTOSO\account' value of the 'EffectiveUserName' XML for Analysis property is not valid. "

Link : https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/

Question:

Is this advisable?

Can an account, which is used to create data sources(the only purpose of is to read data from the data source), be given server admin rights on the Analysis Services Server.

We are going to get more clarification from Microsoft, but has anyone come across this?

 

I dont think  DBA/ IT Security resources usually approve this architecture.

 

Any thoughts people? 

 

2 ACCEPTED SOLUTIONS
v-sihou-msft
Microsoft Employee
Microsoft Employee

@nithinab

 

When configuring Gateway for SSAS data source, the Windows account you enter must have Server Administrator permissions for the instance you are connecting to. Please refer to the Note in doc below:

 

Manage your data source - Analysis Services

 

Reagards,

View solution in original post

Thank You!!!

 

Yes we ended up requesting the accounts to be admins.

 

Cheers

Nithin

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@nithinab

 

When configuring Gateway for SSAS data source, the Windows account you enter must have Server Administrator permissions for the instance you are connecting to. Please refer to the Note in doc below:

 

Manage your data source - Analysis Services

 

Reagards,

Thank You!!!

 

Yes we ended up requesting the accounts to be admins.

 

Cheers

Nithin

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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