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
21 Comments
- 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"
- Please add this feature request. Dataflow's in our organization are unusable unless we have this. Thank you.
- Please include this otherwise the possibilities are limited in power bi service.
- Please add this feature.
- Please add this feature in the next update!!
- Please add this feature !
- Very needed feature and as soon as possible!
- evilchesg
Microsoft Employee
@Greg Galloway - I AM A FAN!!! THANK YOU SO MUCH for this brilliant idea!!!!! *bows down to your greatness* - Agree, it would be good to have this feature available as well.
- Please add this feature. As we have so many SQL Server Analysis Service we current use.
