Bilješka
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati da se prijavite ili promijenite direktorije.
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati promijeniti direktorije.
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 you're connecting to this database for the first time, select the authentication kind and enter your credentials.
Select Next to continue.
In Navigator, select the data you need, and then select Transform data.
Note
Azure Analysis Services connections are currently not supported on the on-premises data gateway.