cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.