Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
442 questions
Error when importing Power BI Premium Model Into Azure Analysis Services
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 33%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
VITOR SILLOS ALONSO
1
Reputation point
I have recently created an Azure Analysis Services model and created a connection with my power BI premium model. This PBI model has the XMLA set to read/write. I have successfully managed to create a connection between the two models using the PBI workspace connection.
In AAS as I click to import tables from the PBI workspace I can see the tables existing in the model and even edit them in Power Query. However, as I go on to process the tables into the AAS model an error pops up saying that an On-Premise gateway is required (the setting AlwaysUseGateway is already set to false). The error is as follows:
'On-Premise Gateway is required to access the data source. Please install a unified gateway for the server ['Server Name'] or disable AlwaysUseGateway setting if it's enabled.
I've looked at the documentation and Analysis Services is a currently valid data source (PBI premium making its connection as a data source through Analysis Services).
Do I really need to set a Gateway to import the tables into my model or am I missing something here?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT 10,136 Reputation points2020-09-24T12:18:21.997+00:00 Hi @VITOR SILLOS ALONSO ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
We are discussing with internal teams to share more insights on this. In order to investigate further, please share the snapshots related to connection with PBI model from AAS. Also, can you please share more details on the use case of accessing PBI model from AAS and please let us know if accessing PBI model from SSMS is working fine. Please share documentation details that discussed about supporting PBI model as data source to AAS that helps in further debugging.
Looking forward for your response.
-
HarithaMaddi-MSFT 10,136 Reputation points
2020-09-28T12:09:11.777+00:00 Hi @VITOR SILLOS ALONSO ,
We have not received a response from you. Are you still facing the issue? If you found a solution, would you please share it here with the community? Otherwise, please share details as requested above and we will continue to engage with you on the issue.
-
HarithaMaddi-MSFT 10,136 Reputation points
2020-09-29T09:07:16.247+00:00 Hi @VITOR SILLOS ALONSO ,
We still have not heard back from you. Please let us know if issue persists and share details as requested above for us to assist you further.
Sign in to comment