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
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.
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
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.