Forum Discussion

rakeshajay's avatar
rakeshajay
New Member
9 years ago

Import Data from Azure Analysis Services

Hi ,   I am trying to import a model from my azure analysis services into my power bi desktop. But, i am have 3 concerns here.   1. The Analysis services memory goes way beyond my actual memory ...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

rakeshajay,

 

Hi AJ,

 

Let's talk about them one by one.

1. Maybe you want to say the size of the model of Analysis is beyond the computer memory. If so, that could be a problem. The memory usage is about the size of the data that is going to be imported. Please reference these topics.

Power-BI-in-memory-RAM-Overload

How-to-Optimize-Memory-Usage

data-import-best-practices-in-power-bi

power-bi-performance-tips-and-techniques

2. According to my test, the whole model was imported as a table. I will do more test later.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3. It seems that the measures are turned into normal columns in the import model.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

These conclusions are tested based on the Azure Analysis Services sample.

 

Best Regards!

Dale