Skip to main content
Microsoft Idea

Power BI

Needs Votes

Installation of Analysis Services Connector should test the connection with impersonation at the end

Vote (5) Share
Greg Galloway's profile image

Greg Galloway on 24 Dec 2014 23:07:08

Step 1: Install the Analysis Services Connector and start the configuration
Step 2: It prompts you to log into Power BI and you log in as x@y.onmicrosoft.com
Step 3: Enter the yourdomain\SSASAdmin credentials and the Tabular server name
Step 4: Enter the friendly name, etc.
Step 5: Please add a new screen which says, "Your connector is configured successfully. Click TEST to test a connection. It will connect under yourdomain\SSASAdmin, confirm that user is an SSAS Admin, then will connect again including EffectiveUserName=x@y.onmicrosoft.com on the connection string to confirm you have AD federated properly so SSAS and yourdomain can impersonate that user."

This should proactively warn users about the most common configuration issue with the SSAS connector:
http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=27

Administrator on 21 Oct 2020 16:32:55

Thanks for the suggestion Greg. Some more troubleshooting information would be helpful here I think! Anyone else agree? Please add your vote!

Comments (1)
Greg Galloway's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:12:09

RE: Installation of Analysis Services Connector should test the connection with impersonation at the end

I agree with the Idea. With the RLS implemented in SSAS, there is no way to impersonated an user in Power BI Service with Live connection. We had to reply on external table and do security based on the table with complex DAX queries.