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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dhooger
Helper I
Helper I

Using Power BI Desktop with SSAS Tabular AND other data

We have an SSAS Tabular cube for the enterprise so IT has control over the data deployed but we want analysts to be able to tie in other data in Power BI Desktop with that cube data. When one starts a PBIX file and chooses Get Data, Analysis Services and connects to the Tabular cube, the Fields show up. However, Get Data now is grayed out to bring other data into the report. We want the security and validation that an enterprise designed and published cube brings but also the flexibility to tie in other data without giving everyone access to change the enterprise cube. Is this possible?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @dhooger ,

Current live connection mode doesn't support to processing multiple datasources.

I'd like to suggest you use import mode to get data from SSAS datasource, then you can add other datasources to live connection mode report.

DirectQuery, Live Connection or Import Data? Tough Decision!

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @dhooger ,

Current live connection mode doesn't support to processing multiple datasources.

I'd like to suggest you use import mode to get data from SSAS datasource, then you can add other datasources to live connection mode report.

DirectQuery, Live Connection or Import Data? Tough Decision!

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

I'm not working with large datasets but Import from an SSAS Tabular cube into PBI Desktop has not once worked for me. I do accept your answer as that is what it is.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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