Power BI Walkthrough: Analysis Services Live Connect

I cannot get passed theverror: this report cannot access the data source. I'm missing something but I don't know what

salog hurtownie dzienki

Hello,
How can we edit the connection string to add the customdata in the power bi services juste like the reporting server ???
I have a report deployed in reporting server and each report have a specific value for the custom data that will be used for rls filter, how can i migrate this to power bi services??

I need help connecting Power BI to my wms system called Exenta. Can you help me?

Can we make a live connection from powerbi to ADLS Gen2 or a SQLServer?

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

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?

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

Thank You

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++ 💥

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

Hi, I've not Analysis Services, so, how can I create a user? It's free or I need a license?

2 years later and it worked like a charm. Thanks

Hi Adam, I've a PowerBI report connected live to my Azure Analysis Services Tabular model, that actually have translations configured. It's working fine in the desktop, but from the service is always showing the labels in English.. I tried to create a dataset (connected live to the tabular model), and a report connected live to that dataset, but it didn't worked aswell. Is there a way to make the traslations work from my tabular model in powerbi service? Thanks in advance!!

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

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

Can a Power BI Capacity Hosted Solution, connect to a SSAS Cube there it on our Servers Live? Power BI Premium P1 ( Power BI Premium capacity-based license)?

We are new to Power BI, but went for a Hosted Model, vs. On-Prem.

Is possible to use PowerBi Web and Gateway without SSAS Tabular, i'm using a multidimensional model

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?

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

Hi..very cool ... but how i can remove LiveConnection?

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

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!!

can I restrict end user from accessing analysis server in power BI Desktop after giving access to workspace ( workspace mail id is in roles ) ?
This is just to force user to use the reports I created for them.

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

An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError
Received error payload from gateway service with ID 2934559: OLE DB connection failed to be established.
OLE DB connection failed to be established
ORA-12154: TNS:could not resolve the connect identifier specified

Hi Whenever I try to connect to database on AAS I get below error

Hello guys, While connecting Power BI report to Azure Analysis Services via Live connection can we create subscriptions on the report?

Hello guy.
I see that you know a lot about sql server / analysis services.
I would be happy if you gave me a light on how to work with cubes in SSAS. Power BI supports connecting to just one, but how to limit access to data for some PBI users? If you create cubes by business area (commercial, product ...), could you share information between cubes without impairing performance?
I'm even looking for someone with this knowledge to do a little consulting with our BI project.

I get this error: "there was an error accessing the data source. contact the gateway administrator.". Any suggestions?

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?

Hi Guy(s)InTheCube (I'm a big fan), but I need some help that I can't get anywhere else on the internet. I'm using Analysis Services Tabular Model, but when passing dates from my model to Power BI or Excel, date hierarchies are not carried over on Live Connection. I could go back to Import instead of Live Connection but this would take my model size and performance back down a step. How can I get dates working as well as Multi-Dimensional, in tabular?

How to access the AD for local SSAS Tabular Server?

Hi, I have a query regarding report server.
We are building a data model and will be using live connection to connect to azure analysis service database.
These report will be used by 200 of them through live connection. How does system distinguish bw Power bi report server credentials and Azure AD credentials while connecting to Power BI report server.
If we want to use a live connection how would that be done is it though Azure AD for all 200 users or we can use a single explicit user credentials for all these 200 users.
Does username and group name should be same for users in both report server and Azure AD, I am not sure on this, it would be great if you can explain me how the access works here in this case

Please let me know if you have not understood my query.

Hey @Guy in a Cube can u please adress to the problem of date hierarchy in live connect. Thanks in advance

Meh not a great story from a vertipac engine perspective...why can’t I see a read-only view of the data model? Kinda funky it requires the gateway account to be a SSAS Server Admin. Be awesome if you did a video on ETL through SQL to SSAS Tabular and another through PBI. Lines of demarcation are just all over the shop these days. Just showing the use case or MS best practices would be great.

I get this error: "there was an error accessing the data source. contact the gateway administrator.". Any suggestions?

Hey I am facing issues while connecting azure analysis services in live connection in power bi..once published to power bi service, i am geeting an error saying "cannot load model"...my analysis servjce is already up and running..and it works perfectly if i use import mode for the same..plz help

whether the analysis service cannot use what if models ?

How can i connecting postgresql live?? Thanks

Very thanks for you

Just a good professional demo. Thanks

Hi currently investigating live connection with SSAS tabular and Import. When I choose import it tries to bring all tables into one table if I select them all at once. Has anyone else found this?

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.

I HAVE A CUBE IN SQL SERVER 2012 (ANALYSIS SERVICE) BUT WHEN I TRY TO CONNECT WITH A LIVE CONNECTION I GET THAT THE FOLLOWING ERROR:
"THIS DATA ORIGIN
DOES NOT ALLOW EXPLORATION WITH A DYNAMIC CONNECTION "

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!