Alex Dupler on 18 Jan 2019 01:17:54
AS is a poor data source for extracting data from for building more tabular models. But sometimes you have no choice. Being able to using dataflow to run those queries once for multiple reports/projects is a great way to reduce the pain of that scenario.
Fully supporting this includes supporting Typed DAX queries for dataflows.
- Comments (2)
RE: Dataflows Native Dax Queries to Analysis Services
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="evaluate TableNameHere"]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"[Measures].[Internet Sales Amount]", Int64.Type}})
in
#"Changed Type"
RE: Dataflows Native Dax Queries to Analysis Services
Totally agree. We have over 2 dozen SSAS Tabular models that are often used to extract summarized data for repeated reuse. This would be a helpful addition for us