Forum Discussion
Power BI Desktop Import Sql Server Analysis Service Tabular Model issues
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...
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?
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.