Skip to main content

Power BI

Needs Votes

SQL Server Analysis Service connection to Dataflow

Vote (216) Share
Michael Cai's profile image

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)
Michael Cai's profile image Profile Picture

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?

Michael Cai's profile image Profile Picture

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.

Michael Cai's profile image Profile Picture

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

Michael Cai's profile image Profile Picture

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.

Michael Cai's profile image Profile Picture

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.

Michael Cai's profile image Profile Picture

Pronab Das on 12 Dec 2022 18:14:52

RE: SQL Server Analysis Service connection to Dataflow

Please provide a native connector for SSAS in the next update.

Michael Cai's profile image Profile Picture

Jamie Burgess on 25 Jul 2022 05:18:12

RE: SQL Server Analysis Service connection to Dataflow

Please add this feature

Michael Cai's profile image Profile Picture

Marian Szetyinszki on 03 May 2022 05:58:12

RE: SQL Server Analysis Service connection to Dataflow

I've been waiting for this for a long time., Poor attitude from MS. Not all customers have Azure AS,

Michael Cai's profile image Profile Picture

Marcelo Conte on 12 Nov 2021 13:52:02

RE: SQL Server Analysis Service connection to Dataflow

Please add this feature option for Dataflow's connectors!!

Michael Cai's profile image Profile Picture

Deepak Mulay on 12 Aug 2021 13:44:33

RE: SQL Server Analysis Service connection to Dataflow

Please add this as soon as possible