cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rakeshajay New Member
New Member

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 when trying to perform the import.

2. When i see the imported data, the relationships are not available? is this the default behaviour?

3. I do not see any measures that i created in my analysis services model? Is this the default behaviour?

 

P.S: Live Connections works fine.

 

Thanks in advance,

AJ

2 REPLIES 2
Microsoft v-jiascu-msft
Microsoft

Re: Import Data from Azure Analysis Services

@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.Import Data from Azure Analysis Services2 .jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3. It seems that the measures are turned into normal columns in the import model.Import Data from Azure Analysis Services .jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft v-jiascu-msft
Microsoft

Re: Import Data from Azure Analysis Services

Hi @rakeshajay,

 

Could you please tell me if your problem was resolved? Please mark the proper answer if it worked. That will be a help to the others.

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors