Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is anyone able to explain me why the following steps break my SSAS native query?
let
Source = AnalysisServices.Databases("xxxx", [TypedMeasureColumns=true, Implementation="2.0"]),
#"SSAS Profit And Loss Actuals" = Source{[Name="SSAS DW Profit And Loss Actuals New"]}[Data],
#"SSAS DW Profit And Loss Actuals1" = #"SSAS DW Profit And Loss Actuals New"{[Id="SSAS DW Profit And Loss Actuals new"]}[Data],
#"SSAS DW Profit And Loss Actuals2" = #"SSAS DW Profit And Loss Actuals new1"{[Id="SSAS DW Profit And Loss Actuals new"]}[Data],
#"Added Items" = Cube.Transform(#"SSAS DW Profit And Loss Actuals new2",
{
{Cube.AddMeasureColumn, "Actual", "[Measures].[Actual]"}
}),
#"Added Items1" = Cube.Transform(#"Added Items",
{
{Cube.AddAndExpandDimensionColumn, "[Item Dimension]", {"[Item Dimension].[Item Commercial Filter].[Item Commercial Filter]"}, {"Item Dimension.Item Commercial Filter"}}
}),
#"Pivoted Column" = Table.Pivot(#"Added Items1", List.Distinct(#"Added Items1"[#"Item Dimension.Item Commercial Filter"]), "Item Dimension.Item Commercial Filter", "Actual", List.Sum)
in
#"Pivoted Column"
Hi v-stephen,
it's SSAS so I cannot provide you with dummy data. However the issue is quite simple - after pivoting the native query is broken. While I can still have it done on client side, I would like the pivoting step to happen on server side. Is this possible?
Hi @plomb ,
Sorry I can't reproduce it. Please tell me what error message did you get?
Or present your table with dummy data and share me with expected result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.