Forum Discussion
Assistance Needed with Dataset Refresh Issue
hello TBBD
The dataset refresh issue you’re encountering typically occurs when ownership transfer doesn’t automatically resolve credential dependencies.
The dataset refresh failure stems from identity dependency chains in Power BI’s authentication model. When Moazzem’s Azure AD account was deleted:Power BI datasets store encrypted credentials using the original creator’s:
• Azure AD Object ID
• User Principal Name (UPN)
• Security group membershipsThe dataset’s scheduled refresh attempts to use:
• Original OAuth tokens tied to Moazzem’s identity
• Database permissions granted to Moazzem’s SQL login
• Gateway configurations authenticated via Moazzem’s credentialsAdmin ownership transfer doesn’t automatically recreate this delegation chain.
To resolve the dataset refresh failure caused by the deleted Azure AD account, first ensure full ownership transfer via the Power BI admin portal or REST API, then manually purge and reconfigure all data source credentials using your admin account’s identity, update Azure SQL permissions and gateway configurations to reflect the new ownership, replace any residual user-specific references in M queries or RLS rules, and set up service principal-based authentication for long-term stability, followed by validation through test refreshes and monitoring via Azure Monitor to confirm resolution.
If this is helpful please accept the answer
Hi TBBD,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
Hi TBBD,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thankyou.
Hi TBBD,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thankyou.