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
javanoide
Regular Visitor

SSAS Tabular in Azure need on premise gateway?

Hi Everyone,

 

I need a help, I just started to use power bi and I have a doubt.

 

I have SSAS with a tabular model in Azure and I will use it in a power bi desktop file to create my report.

 

For this scenario, in order to publish my report in power bi service i will need to install a gateway on my server? 

 

I belive that for Azure data source I don't need, am I correct? And since It's tabular model there is no refresh and is always update, ok?

 

I'm asking this because I received an email from a friend showing a message requiring an enterprise gateway to refresh data.  Is this a requirement for PIBX files? If I use just power bi service I don't need a Gateway?

 

I'm a little confused about that.

 

Thank you all.

2 ACCEPTED SOLUTIONS
v-yuezhe-msft
Employee
Employee

@javanoide,

Do you connect to Azure Analysis Services in Power BI? If so, gateway is not required when your dataset only contains the Azure Analysis Services data source.

After you publish the PBIX file to Power BI Service, you will find that Power BI Service connects directly to your data source.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@javanoide,

When you connect to SSAS which is installed in Azure VM and refresh this dataset, gateway is required.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yuezhe-msft
Employee
Employee

@javanoide,

Do you connect to Azure Analysis Services in Power BI? If so, gateway is not required when your dataset only contains the Azure Analysis Services data source.

After you publish the PBIX file to Power BI Service, you will find that Power BI Service connects directly to your data source.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lydia,

 

The same behaviour applies when you have a SSAS as in IaaS mode (VM on Azure with SQL and Analysis Service)?

@javanoide,

When you connect to SSAS which is installed in Azure VM and refresh this dataset, gateway is required.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Many Thanks Lydia

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
Top Kudoed Authors