Forum Discussion
Import data from SSAS Tabular model
Anonymous,
You may do research into The Advanced Editor.
https://msdn.microsoft.com/en-us/query-bi/m/power-query-m-reference
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!
No, I haven't gotten the solution. Sorry.
I think I may have found a workaround. You connect to AS and when you can choose which tables to load, you only choose one table. You load it (or edit first and then load) and then you connect again to AS via Get Data and choose another table, and so on, until all the tables needed are imported.
But for my case, I think DirectQuery is the better connection option.
Hope this helps!