Skip to main content

    Power BI

    New

    SQL Server Analysis Service connection to Dataflow

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

    d2dd4ad8 e575-4fcb-b8aa-d30a930a7c95 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

    9d8b4543 51d9-4991-b77c-a5fbc0ed4eab 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

    8a777968 3b23-4f39-86ca-f945400bd90d 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

    e67b8764 a52d-49ec-91b2-154744ee79f3 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

    cca3b4fe 341b-4612-8d55-4ee5e8c0b701 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

    2ac8871c 8872-ea11-a811-000d3a579c38 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

    3a421735 e65c-42a0-a282-be4bf40fa7a7 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"