Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    SQL Server Analysis Service connection to Dataflow

    Vote (210) 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 (19)
    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

    Michael Cai's profile image Profile Picture

    Jamie Burgess on 03 May 2021 22:16:00

    RE: SQL Server Analysis Service connection to Dataflow

    Please add this feature. As we have so many SQL Server Analysis Service we current use.