Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Changing User Suffix

I have a scenario where we need to bulk change a number of UPN suffixes in O365, for users that have access to PowerBI reports and datasets.

 

Old UPN suffix @mydomain.nz

New UPN suffix @mydomain.co.uk 

 

User accounts are sync'd from on-premises AD, and changing the suffix successfully synchronizes to O365, and in turn the users can now login to PowerBI with their new suffix.

 

Everything previously shared with them is visible, and if they try to access anything where SQL is the connection, then this works without error.  However, if they try to access anything where Analysis Services is the connection type, they now get the error "The Report Couldn't access the data source. Contact XXXX, the author to have it fixed"

 

The users on-premises SamAccountName doesn't change, so the on-premises permissions shouldn't be an issue. 

Any ideas how we update this in bulk, without having to reshare everything? 

 

Interestingly enough, if the same user logs on to PowerBI Desktop, and not the online app, then everything works fine.
If we change the suffix back to @mydomain.nz this instantly resolves the issue.

 

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @Anonymous 


Can you confirm that you have updated the user mapping when going to Analysis Services on-premise where you changed it from the old account to the new accounts?

 

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hi @GilbertQ 
Would something need to change on-premises? 
As the mapping on-premises appears to be to the SamAccountName (domain\user) which doesn't change at any point. 
All we are changing is the UPN, and as far as I can see Analysis Services doesn't read from here.

 

I have looked at the EffectiveName mapping, and I don't think this applies here.  As after the suffix change, both the account I login to PowerBi with and the on-premises UPN match.  So I'm not trying to change it's mapping.

 

Before the change the sign in to PowerBI is @mydomain.nz and the UPN is also @mydomain.nz - this works 
After the change the sign in to PowerBI is @mydomain.co.uk and the UPN is also @mydomain.co.uk - this doesn't

Thanks 

Hi @Anonymous 

 

Did the internal domain also change?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors