SQL Server Analysis Service connection to Dataflow

[Michael_Cai]

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

[fbcideas_migusr]

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"

[Julius_Henderso]

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

[aby_mathew]

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

[E353303]

Please add this feature.

[Pritesh_AMIN]

Please add this feature in the next update!!

[contact11]

Please add this feature !

[ardak_zhanalino]

Very needed feature and as soon as possible!

[evilchesg]

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

[zbpor1]

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

[Jamie_Burgess]

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