Power BI Walkthrough: Analysis Services Live Connect

Adam walks through how to setup a live connection to Analysis Services, or Azure Analysis Services, in Power BI Desktop. This also involves getting things working with the On-Premises Data Gateway.

********
LET'S CONNECT!
********

***Gear***

[ovdaddy]

2 years later and it worked like a charm. Thanks

[johng]

Thanks in a million! Very well explained. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥

[alexkim]

Wow that's insane how you made it sound so easy to understand.

[Riya-bnjy]

Explained in such simple words... Yet to do it, will surely come back if I have doubts :D

[peterdoyle]

Just a good professional demo. Thanks

[roxnroll]

Great video - though I'm already lost at the very first step! LOL... @1:40 you mention enter the server name. What would that be if the server is on AWS EC2 instance? (not local). Microsoft's own website lead me here - so now I'm in a crazy loop without knowing how to do this... I watched the whiteboard video - but didn't really help.

[pradeepyadagani]

Thank you for Video. Can we use Analysis Services from Power Dataflow? Didn't see such option in Power BI online. And is there a way to use LIVE connection along with IMPORT?

[devmank]

Great video ! Could you answer this question (or create a video) on connecting to Analysis Services VIA HTTPS using OLE DB and how that impacts the gateway. I've a report using HTTPS Analysis Services to the DLL which works in PBI Desktop but once published cannot refresh as the Gateway says it needs to be setup. I would think we would not need the Gateway at all. Thoughts?

[prabhatdass]

Hi Adam, i need to know how we can check the total refreshing/processing time of a AAS model.

[VishalGupta-tczl]

The only problem for us is we cannot add another dataset when we choose live connection. So if we have to use analysis service live connection with local dataset then it is not supported.

[tonisergi]

I'd llike to know how you made that awesome visual, that's the part I struggle with.

[GaryMWilson]

Thanks for another great video! Could you elaborate on what you said about not choosing import in general for Analysis Services? Why is there "a lot of badness there"? I agree with you but others think they need to be able to do this and then publish the pbix file to an on-prem Power BI Report server that is set up to connect to the same SSAS model the data was imported from.

[chandeepsingh]

Hi, I have a query regarding Dashboard based on live connection in cube. Are you able to download the underlying data?

[sreeramgodavarthy]

Hey Adam, Is there a way we could test RLS applied on SSAS model directly on Power BI, instead of using DAX Studio?

[melianiferiel]

Thank you a lot for this video.
I’m struggling with translations that are implemented on Ssas tabular. Everything work fine when we connect to the Ssas instance via Excel.
But metadata translations don’t appears to work once the report published on power BI report server and even in power BI desktop. I’m not sure if translations on Ssas live connexion are supported by Power BI

[joshuaharvey]

If you get a chance to add a link to either of those two videos you mentioned that would be great (authentication and gateway). Thanks for a great video though guys!

[COkllr]

Hey guys fantastic video, thanks!. just a quick question: is there a way i can control whether or not excel uses DAX or MDX in background when live connecting to a SSAS tabular?. i've been using DAX Stuidio yo review the queries sent to the tabular and found out that when you do something from EXCEL it queries the tabular on MDX, is it possible to force it to use DAX?

[amirdaud]

I am using Power Bi with Analysis services. There is no Calculated measure in the modelling tab.

[annnnnnnnnnnnnnnnnnnnnn]

Hi,
Thanks for your sharing. Could you help me in this case:

In our server we have an SSAS database. I use PBI desktop in my REMOTE SERVER MACHINE to connect the SSAS database and then publish this dataset in PBI service. I can create report using this dataset in PBI service. But when I try to connect this dataset using PBI desktop on my PERSONAL COMPUTER it has an error. It works when I connect using PBI desktop in my REMOTE SERVER MACHINE.
How can I connect SSAS dataset in PBI Service from my personal computer?

[krishkrishna]

Hi,

I have a situation in power bi, i am unable to figure out. Wondering if you had any issues with SSAS live connection and inactive relationship within the data model ?

Any help is highly appreciated.

Thanks!!