Power BI

Needs Votes

SQL Server Analysis Service connection to Dataflow

Vote (216)

Michael Cai on 28 Oct 2019 04:39:15

Support Dataflow connections to SQL Server Analysis Service (SSAS), which desktop data sets allow users to do.

At the moment, dataflow does not even support the use of a copied M script from desktop connected to SSAS in a blank query.

See forum post below:
https://community.powerbi.com/t5/Service/SQL-Server-Analysis-Services-as-a-Dataflow/m-p/828241#M79336

Comments (20)

Comments (20)

John Ellis on 15 Sep 2024 09:43:03

RE: SQL Server Analysis Service connection to Dataflow

Did this actually happen?? Did support for dataflow accessing On-Prem SSAS get include in a release?

Geoff Fawcett on 30 Oct 2023 16:34:24

RE: SQL Server Analysis Service connection to Dataflow

Yes, yes. This is really needed. There is a ton of corporate data living in SQL Analysis Services, even right here within Microsoft. Often there is no way to get to the backend sources, and the SQLAS models have added essential semantic layer constructs / metrics / etc. Really need a connector for this data source.

David Power BI User on 22 Mar 2023 21:57:54

RE: SQL Server Analysis Service connection to Dataflow

It has been four years, but it looks like Microsoft is ready to improve dataflows, and allow us to connect to on-prem SQL SSAS.Here is the release wave for 2023, with a "public preview" in April:Use the SQL Server Analysis Services connector in Power BI dataflowshttps://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/data-integration/sql-server-analysis-services-connector-power-bi-dataflows

Josdeyvi Magalhes Russi on 10 Mar 2023 21:40:37

RE: SQL Server Analysis Service connection to Dataflow

Same ideia for Datamarts. Today if you have a complete model in SSAS with 30 tables, you must redo the work in a Datamart.

Selvakumar Kuppa Ramalingam on 13 Jan 2023 00:33:47

RE: SQL Server Analysis Service connection to Dataflow

SSAS connector is available in Power BI to create datasets but not in Dataflow so we can't create SSAS datasets via Dataflow.This looks disappointing as the connectors are not in sync with in Power BI between Power BI report dataset with Dataflow dataset.Please add this connector.