cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Retha Frequent Visitor
Frequent Visitor

objects missing with live connect to SSAS

I'm using live to connect to a multidimensional cube on SSAS, but not all my dimensions are visible. When I use import all of the missing one are available.

Why is that, and what can I do to add the missing objects?

Or am I missing something?

11 REPLIES 11
WolfBiber Member
Member

Re: objects missing with live connect to SSAS

Hey,

have a look to the documentation in section 

Supported Features of SSAS MD in Power BI Desktop

https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional

Retha Frequent Visitor
Frequent Visitor

Re: objects missing with live connect to SSAS

Had a look, but nothing there to explain why some dimensions (created the same way) are not pulling through with live

WolfBiber Member
Member

Re: objects missing with live connect to SSAS

Maybe a perspective or security Problem? 

I have no trouble working with live connection and SSAS MD

Retha Frequent Visitor
Frequent Visitor

Re: objects missing with live connect to SSAS

Thanks for the response. I'm not sure as 99% of my dimensions and hierarchies does pull through it is just 2 of them that doesn't. If I use Excel, Proclarity and import they do pull through. 

Unfortunately I cannot use import, as the amount of data is moer than 1 GB.

Do you think it could be the size of the cube?

Moderator v-yuezhe-msft
Moderator

Re: objects missing with live connect to SSAS

@Retha

How about you use Excel to connect to SSAS? Do you get all dimensions?

Regards,
Lydia

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

Re: objects missing with live connect to SSAS

@v-yuezhe-msft, yes I get all dimensions when I connect with Excel to SSAS. I even get all testing with import. It is just with live that I'm experiencing the issue.

Moderator v-yuezhe-msft
Moderator

Re: objects missing with live connect to SSAS

@Retha,

Do you use the latest version of Power BI Desktop(2.52.4921.682 )?If so, clear cache in Power BI Desktop and check if the issue still occurs.
1.JPG

If the issue persists, I recommend you reboot machine, re-install Power BI Desktop.

Regards,
Lydia

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

Re: objects missing with live connect to SSAS

Lydia

 

Thanks for the response.

I did clear the cache and rebooted my machine, but the issue are still there.

Will try the re-install now, and see what happens.

Retha Frequent Visitor
Frequent Visitor

Re: objects missing with live connect to SSAS

Also reinstalled and rebooted, but no luck.

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.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors