Error when importing tables from Power BI Premium into Azure Analysis Services
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?
You may have to use a on-premise data gateway that can reach the data source.
The on-premises data gateway provides secure data transfer between on-premises data sources and your Azure Analysis Services servers in the cloud.
In addition to working with multiple Azure Analysis Services servers in the same region, the latest version of the gateway also works with Azure Logic Apps, Power BI, Power Apps, and Power Automate. While the gateway you install is the same across all of these services, Azure Analysis Services and Logic Apps have some additional steps.
Reference: Connecting to on-premises data sources with On-premises data gateway and On-premises Data Gateway for Azure Analysis Services.
- Azure PowerShell command to list all Azure VM SKU Sizes enabled for Confidential Computing Azure ACC
- Create Azure TimerTrigger Durable Function in python
- Azure File Share: Cannot map network drive
- RBAC with bicep
- ADF expression to convert array to comma separated string
- How to get status of Azure machine learning service pipeline run using Rest Api?
- How do I deploy a Nuxt 3 solution to an Azure Node Web App
- Azure Blob Upload not working in ASP .Net Core Application
- How to clear a Cosmos DB database or delete all items using Azure portal
- Using script commands, how to add multiple scale rules to an Azure Container App?
- User Assigned Managed Identity: No User Assigned or Delegated Managed Identity found for specified ClientId/ResourceId/PrincipalId
- Generate resources dynamically from another group of dynamically generated resources in Terraform
- Column reordering in ADF
- Logic App AuthorizationFailure - vnet integration needed
- Azure blob, controlling filename on download
- Azure VNet peering with Private Link
- Get Private FQDNs, IPs, Names of the Private Endpoints for the Azure resources deployed in an Virtual Network using PowerShell Script
- How to configure appsettings on a auto-generated preview environment
- Using Azure DevOps, how do I migrate a release pipeline to code, similar to build pipeline yml?
- Root login Ubuntu VM on Azure
- Filtering azure devops release build based upon build tag with "Continuous deployment trigger"
- Azure WebApp autoscale
- How to handle long startup times in Azure App Service deployment
- Frontend not available when front and back on same Web App Azure
- Use Salesforce Connectors from Hosted Azure Logic App in VSCode?
- What is considered an ingestion request in Azure Data Explorer?
- Provisioning (SCIM) by Entra/Azure: Why can I not select the "groups" attribute in my attribute mapping?
- Azure function verbose trace logging to Application Insights
- Azure function app GraphServiceClient create list
- Cypress tests fail to run in parallel mode due to mismatched specs between different runs