Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
maxsnow
New Member

Power BI and Azure Analysis Services perspectives

Hi Guys

 

I've created several perspectives in Azure Analysis Services project.

 

Is there any way to select a perspective when connecting from Power BI to AAS?

Looks like it connects to a default perspective without giving a choice.

 

Regards,

Max

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

hi, @maxsnow

     When you use Connect live to connect to AAS, you can only select the whole model, when you choose import,

you can select tables by yourself.

 

Best Regards,

Lin

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

Hi @v-lili6-msft 
when importing data from AAS and you have the perspective and a set of tables to select your columns from.  After selecting your columns can you filter the data by a specific value in a column and then import the data?  This is to reduce the qunatity of data transfer to the power bi otherwise the AAS runs out of memory due to the volume. e.g i need only 2million records to import to power bin stead of the available 10 million rows for the multi-table column selection

Thanks 

Aktahr

This seemed to be working now. 

If you use Live connect, don't enter the database name, on the next screen you'll get an option to connect to a specific perspective. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.