Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can connect Dataflow Gen2 to Azure Analysis Services in Microsoft Fabric using Power Query connectors. Follow these steps to create your connection:
- Check capabilities to make sure your scenario is supported.
- Complete prerequisites for Azure Analysis Services.
- Get data in Data Factory in Microsoft Fabric.
- Connect to Azure Analysis Services.
Supported authentication types
The Access database connector supports the following authentication types for copy and Dataflow Gen2 respectively.
| Authentication type | Copy | Dataflow Gen2 |
|---|---|---|
| Organizational account | n/a | √ |
Capabilities
- Import
- Connect live (Power BI semantic models)
- Advanced options
- MDX or DAX query
Prerequisites
An Azure subscription. Go to Get Azure free trial.
An Azure Analysis Services server. Follow the instructions at Quickstart: Create a server - Portal for creating the server using the Azure portal. Other articles in this section also include information on creating a server using PowerShell, Bicep, or an Azure Resource Manager (ARM) template. This connector article assumes that you already created an Azure Analysis Services server and have an existing database on the server.
Connect to Azure Analysis Services
To make the connection, take the following steps:
Select the Azure Analysis Services database option in the connector selection. More information: Where to get data
In the Connect to data source page, provide the name of the server and database (optional).
If needed, select an on-premises data gateway.
If you're connecting to this database for the first time, select the authentication kind and input your credentials.
Select Next to continue.
In Navigator, select the data you require, and then select Transform data.
