Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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 

      • GilbertQ's avatar
        GilbertQ
        Super User
        3 years ago

        Hi Anonymous 

         

        Did the internal domain also change?