Forum Discussion
Import data from SSAS Tabular model
In PB Desktop, I am connecting with "Import" mode to a basic Tabular SSAS model with 3 tables. However when imported into powerBI I have the results：
1. Only a single (Model) table with all fields was created and it is a mess without order. I would like to see 3 separated tables. why is this?
2. The number of records in that (Model) table became very large and equaled to
(the # of rows in table-1)*((the # of rows in table-2)*(the # of rows in table-1).
That's why I got the "memory insufficient error" when I tried to import all the 13 tables in same time.
why is this?
appreciate if anyone can help.
12 Replies
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"
Hi All,
I got a very similar issue. As I'm tasked to explore the feasibility of importing an Azure Analysis Service model into Power BI, I'm able to import each table one by one (but it's extremely slow even though I'm on a AAS S2 tier), but as soon as I import two tables it fails with the following error message:
Connecting live works fine but then users cannot create their own columns nor add other datasets to the report.
If anyone could share a workaround, that would be much appreciated.
Thanks
