March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
We have a Power BI Enterprise gateway running on a local server. It provides access to both Oracle and our on-premise Analysis Services Olap and tabular servers from our Power BI Service. It works great.
We are evaluating Azure Analysis Services as an alternative to maintaining op-premise SSAS tabular servers. We have the Azure Analysis Services instance up and running and deployed a small tabular model with data sources pointed back at our Oracle data warehouse. These same data sources and queries exist for several of our Power BI reports which refresh with no problem.
After deploying I looked at connecting the Azure Analysis Services database to our On-premise gateway. The documentation sources seemed to indicate that the Azure gateway was different than the Power BI gateway.
Can I use the existing Power BI enterprise gateway for Azure Analysis Services or do I need to setup one just for Azure? If I have to install another instance, can I have both the Power BI and Azure gateways on the same local server or do I have to have then on different servers?
Thx, Mike
Solved! Go to Solution.
@Anonymous I haven't done this directly yet, but from my understanding it is currently a seperate gateway. As described here it's based on the same OPD Gateway that Power BI uses, so i would imagine it is only a matter of time before this is no longer seperate. If I read things correctly, I would assume that you would need to install this on a seperate server than the current one you have running for Power BI.
I just recently came across this same thing - I had an existing Power BI Data Gateway installed in my on-prem environment, and we decided to switch to the SSAS/AAS model. After some troubleshooting, I had to remove the Power BI Data Gateway and install the separate (but similar looking) Azure Data Gateway.
I read somewhere on the forums that Microsoft is planning on joining these two together, but for now, they are separate.
This is enormously confusing...I'm now stuck trying to figure out what gateway I am using. I guess I will open a support tikcet but Microsoft, PLEASE do not do things lke this...making similar but different components for PowerBI reduces adoption!
Hello ,
Was your problem resolved? I believe that for Azure Analysis Servce you do not need any gateway at all, since the Azure Analysis Service is hosted on cloud and is not on preminse, where it needs a secured connection pipeline.
Thanks for the feedback to both of you. We are moving ahead with installing the Azure Gateway on a separate VM from the PowerBI Gateway.
@Anonymous I haven't done this directly yet, but from my understanding it is currently a seperate gateway. As described here it's based on the same OPD Gateway that Power BI uses, so i would imagine it is only a matter of time before this is no longer seperate. If I read things correctly, I would assume that you would need to install this on a seperate server than the current one you have running for Power BI.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
21 | |
16 | |
13 | |
12 | |
9 |
User | Count |
---|---|
34 | |
31 | |
20 | |
19 | |
17 |