Current position:  Home > Default > Will the Power BI Analysis Services Connector work if AD and AAD UPN suffixes don't match?

Will the Power BI Analysis Services Connector work if AD and AAD UPN suffixes don't match?

Time:November 30
Advertisement
We are using Azure Active Directory, AD FS, and DirSync with
Alternate Login IDs, which means that our on-prem usernames have a different UPN suffix from our AAD usernames.
Will the Power BI Analysis Services Connector work in this setup? Or do the AD and AAD UPN suffixes absolutely have to match?
Advertisement
Hey Adam,
From SSAS, we simply query AD by passing the UPN we receive from AAD. As long as AD can find a match, it'll work.
So if there is a way in AD to map a particular UPN to another value, it'll work.
For example: For a user A, her on premises UPN is
'[email protected]' but she uses '[email protected]' as her email address. From AAD we'll receive
'[email protected]' & since AD knows that this is same as
'[email protected]' effective user name will work.
Hope this clarifies! let me know if you have more questions.
-mini

Power BI analysis services connector - the remote server returned an error (403)

2015-10-11

Hi all, does any one have any suggestions what to try to identify the configuration problem I have? I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions.  When configur

Connection issue for Power BI Analysis Services Connector

-0001-11-30

Hi, I have a problem with the connection to power bi. the analysis services connector was installed correctly and I see in my account of power bi the tabular server, but, when wanting to deploy database it marks me the following error: IMDExternalCon

What's my password....Power BI Analysis Services Connector Deep Dive

-0001-11-30

Here are three screen shots: SSMS: PowerBI connected: What's my password?Hi Greg, According to your description, you want to know the what you need to put when logging on to SSAS. Right? In Analysis Services, Analysis Services provides a role-based a

PowerBI Analysis Services Connector Error 403

-0001-11-30

Hi all, I have a problem with the configuration of PowerBI Analysis Services Connector. I fill all fileds but i have an error in the last step. Error description: "The remote server forward an error: Forbidden (403)" I don't understand this erro

Can't connect to BI Analysis Services Connector

-0001-11-30

Hi all, I had tried to connect with BI Analysis Services Connector. I had done all steps, but when I tried to connect with BI Analysis Services Connector, can't view cubes and appear a error message. This don't have specifications. Technical details:

Bad Request error on Analysis Services Connector

-0001-11-30

I'am trying to connect my PowerBI preview account to a tabular instance on a Azure Virtual Machine and always fail at the end with this error: The remote server returned an error: (400) Bad Request. [UTC TIMESTAMP: 2/19/2015 12:20:49 PM] [REQUESTID:

The schedule in Power BI report refresh error with the powerpivot or powerview with SQL Analysis services as data source

2015-10-11

In the Power BI Admin Centre, the data sources that cannot be setup with Analysis services, and it has the error to schedule the powerpivot or powerview report to have data refresh. The error is "我們無法重新整理此報表中的資料來源種類." - english, "We can not

Accessing Analysis Services MultiDimensional cube data with Power View in Excel

-0001-11-30

At this point in time, does Power View in Excel have the ability to connect directly to an Analysis Services multidimensional cube? If not, is this functionality expected in the near future? davidg12Hi, As far as I known, the Power View for Excel doe

I am unable to see following SQL Server Analysis Services in central admin services after the SQL 2014 power pivot installations

-0001-11-30

I am unable to see following SQL Server Analysis Services  in central admin services after the SQL 2014 power pivot installations RaviHi Ravi, Per my knowledge, there is no Analysis Service in SharePoint. After running the SQL 2014 setup to install P

SQL Server 2005 Analysis Services across domains

-0001-11-30

Hi, With SQL Server 2000, the Enterprise Edition was required to access Analysis Services across domains. Is this also the case in SQL Server 2005, that the Enterprise Edition is needed? Thanks, SSilver, Do you still need help with this? Thank you! E

Can't connect to analysis services

-0001-11-30

Hi, After looking through the forum, I haven't seen the problem I encounter. I am able to connect to the Database Engine, Integration services, Reporting Services but I can't connect to Analysis Services from SQL Server Management Studio although the

MS SQL Server Analysis Services (SSAS) OLAP Connection - Dimension descriptions

-0001-11-30

Hello, We are trying to create some reports on BO 4.0 on top of BPC 10 MS information. In order to overcome some issues related to standard connector between BO and BPC (XMLA Planning and consolidation 10 for Microsoft platform), we created a new con

Non Windows Credentials Sql Server Analysis Services

-0001-11-30

I am attempting to connect to an OLAP cube using power query from sql server analysis services, but without windows credentials.  Is there a way in which I can perform this action?  It doesn't seem to support this type of connection without using win

SQL Server Analysis Services (PowerPivot) instance returned the following error:

-0001-11-30

SQL Server Analysis Services (PowerPivot) instance returned the following error: Error Code: 3241607174 Description: A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook, file 'C:\Program Files\Microsoft SQL

PowerPivot and Analysis Services tabular instance in SharePoint

-0001-11-30

Hello, If I connect to the SQL Server 2012 SP1 Analysis Services tabular instance in SharePoint 2010 that houses all of the PowerPivot files that have been uploaded to our SharePoint environment, I only see a portion of the models  that exist. Why is

Analysis Services Tabular Model 2014 vs 2012

-0001-11-30

Hi, A very simple question : with the same tabular model is 2014 faster than 2012 from query point of view (is the Storage Engine or Formula Engine faster than the previous version ) ? Thanks Hi MIB1, According to your description, you want to know i

How to get data from MySQL into Analysis Services Tabular Model

-0001-11-30

Hi, I have a problem with Analysis Services Tabular Model and MySQL ... I have to use several MySQL databases as a source of Tabuar Model .. Is there any way to get connection working from Tabular Model to retrieve data from MySQL database. I have a

WISH : Excel Analysis add-in without SQL Server Analysis Service

-0001-11-30

WISH : Excel Analysis add-in without SQL Server BI Edition. I want to use Excel Analysis functionality on my Excel without SQL Server Analysis Service. LIKE Excel Power Pivot , can use without SQL Server Tabluer Service. Yes, Excel Power Pivot have l

Refreshing the Data Source View in Analysis Services

2015-10-11

I have added columns to the SQL Database table that is used as a dimension in an Analysis Services Cube.  The new columns will be used as additional Property Fields for the dimension.  When I attempted to refresh the Data Source view so that the addi