Forum Discussion
Import data from SSAS Tabular model
Dear Sam,
I looked the Advanced Editor and the M Language reference. But I still don't understand how to solve the "import" issue.
When I choose 3 tables from SSAS Tabular model using "import connection" I will get only 1 table in PBI Desktop model with all columns joined. The script of the Advanced Editor looks as below.
Should I modify the script or change any settings to get the correct result?
I also couldn't find too many guides in how to "import" SSAS Tabular model to PBI Desktop.
Thanks,
Jack
----------------------------------------------
let
Source = AnalysisServices.Database("192.168.12.51\pb_db2", "TabularProject1", [TypedMeasureColumns=true]),
#"TabularProject1 Model1" = Source{[Id="TabularProject1 Model"]}[Data],
#"TabularProject1 Model2" = #"TabularProject1 Model1"{[Id="TabularProject1 Model"]}[Data],
#"Added Items" = Cube.Transform(#"TabularProject1 Model2",
{
{Cube.AddAndExpandDimensionColumn, "[DimProduct]", {"[DimProduct].[ChineseDescription].[ChineseDescription]",...
{Cube.AddAndExpandDimensionColumn, "[DimProductCategory]", {"[DimProductCategory].[EnglishProductCategoryName].[EnglishProductCategoryName]", ...
{Cube.AddAndExpandDimensionColumn, "[DimProductSubcategory]", {"[DimProductSubcategory].[EnglishProductSubcategoryName].[EnglishProductSubcategoryName]", ...
})
in
#"Added Items"
Have you managed to fix the issue? I am facing the same problem! Using Direct Query on AAS I can get the separate tables the way I have defined them in Analysis Services, whereas importing results in one big table with all the measures and dimensions into one :o Big mess!