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

    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.

    Michael Cai's profile image Profile Picture

    Zbigniew Porzych on 20 Jan 2021 08:16:35

    RE: SQL Server Analysis Service connection to Dataflow

    Agree, it would be good to have this feature available as well.

    Michael Cai's profile image Profile Picture

    Erika Vilches on 23 Oct 2020 06:02:05

    RE: SQL Server Analysis Service connection to Dataflow

    @Greg Galloway - I AM A FAN!!! THANK YOU SO MUCH for this brilliant idea!!!!! *bows down to your greatness*

    Michael Cai's profile image Profile Picture

    Ardak on 06 Jul 2020 00:17:14

    RE: SQL Server Analysis Service connection to Dataflow

    Very needed feature and as soon as possible!

    Michael Cai's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:12:42

    RE: SQL Server Analysis Service connection to Dataflow

    Please add this feature !

    Michael Cai's profile image Profile Picture

    Pritesh Power BI User on 06 Jul 2020 00:09:57

    RE: SQL Server Analysis Service connection to Dataflow

    Please add this feature in the next update!!

    Michael Cai's profile image Profile Picture

    Ricardo Pereira on 06 Jul 2020 00:09:01

    RE: SQL Server Analysis Service connection to Dataflow

    Please add this feature.

    Michael Cai's profile image Profile Picture

    Aby Mathew on 06 Jul 2020 00:08:26

    RE: SQL Server Analysis Service connection to Dataflow

    Please include this otherwise the possibilities are limited in power bi service.

    Michael Cai's profile image Profile Picture

    Julius Henderson on 06 Jul 2020 00:07:39

    RE: SQL Server Analysis Service connection to Dataflow

    Please add this feature request. Dataflow's in our organization are unusable unless we have this. Thank you.

    Michael Cai's profile image Profile Picture

    Greg Galloway on 06 Jul 2020 00:06:29

    RE: SQL Server Analysis Service connection to Dataflow

    I agree this would be a nice enhancement.

    In the interim it appears you can switch to OLE DB and accomplish this... for example:

    let
    Source = OleDb.DataSource("Provider=MSOLAP;Data Source=ServerNameHere;Initial Catalog=DatabaseNameHere;", [Query="select [Measures].Members on 0 from [Adventure Works]"]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"[Measures].[Internet Sales Amount]", Int64.Type}})
    in
    #"Changed Type"