Power BI Desktop Import Sql Server Analysis Service Tabular Model issues

[Anonymous]

In my PB Desktop, I am connecting with "Import" mode to a basic Tabular SSAS model with just a 

Dimension table and a Fact Table based on the AdventureWorks sql database 2019. I have built the model in Visual Studio 2019 by following all the instruction from official Microsoft Learn link and deployed it successfully. I created calculated columns, Measures and KPIs all with success.

However, when import 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 the 2 separated tables. why is this?

2. The number of records in that (Model) table became very very large like it is equaled to

     (the # of rows in table-1)*(the # of rows in table-2).

and it cause  the "memory insufficient error" when I tried to import the 2 tables in same time.

3. All the columns that are numeric in my ssas model are imported as text!!!!! I have to change the type of each column in the power bi power query.

4. The KPI are not imported correctly: for each KPI on the model, power bi import as three different column for each value, status and target

If I connect to the ssas model in Direct Query I don't have any of the problem but the requirement is to have the import!

Anyone can help me please?

Thanks

[Anonymous]

User wants to load data from SSAS Model with import and load other data from excel, so we need the import.

Why do you ask about the requirement? If the import mode is not the best choice to work with SSAS model why it is available?

[lbendlin]

SSAS is a multi dimensional cube.  Import mode will force you to flatten that out.
In addition a cube usually has many millions of rows and lots of dimension tables. Importing all of these will take a lot of time and resources.

If you go for Import mode you will want to specify a very narrow MDX query.

[Anonymous]

The requirement is the possibility to connect to Analysis Service  and to connect also to an Excel file so the only possibility is to cnnect to Analysis Service in import mode 

[lbendlin]

Have you considered cutting Power BI out of the picture and connecting to SSAS directly from Excel?

[Anonymous]

I tryed from Excel and it works, but I must do the report on Power BI

[lbendlin]

"the requirement is to have the import"

Please explain why that is a requirement.  Normally that is only necessarey when you do not have control over the cube.