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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
NickChyhyr
New Member

Datamart error: Cannot open a datamart

When I try to open the datamart I get an error:  User not authorized for datamart


User who created this datamart has been removed from Power BI
I tried to takeover the datamart but nothing happened

2 REPLIES 2
NickChyhyr
New Member

I am a workspace admin and I can see myseld in the "direct access" list for this datamart
It looks like settings page just freezes when I try to takeover the datamart
I cannot expand any property and "takeover" button  do nothing  (

Anonymous
Not applicable

Hi @NickChyhyr 

 

The error message "User not authorized for datamart" and the fact that the user who created the datamart has been removed from Power BI suggest there are permission issues at play. Here are some steps you can take to resolve this issue:

 

  1. Power BI Service Administrator Role: Ensure that you have the necessary administrative privileges within Power BI service. If you are not an admin, you may need to contact someone who has Power BI Service Administrator role to assist you.

  2. Attempt to Take Over: You mentioned trying to take over the datamart but with no success. Make sure you are following the correct procedure to take ownership:

    • Go to the datasets in the Power BI service.
    • Find the dataset that is connected to the datamart.
    • Use the 'Take Over' option.

  3. Check the Datamart Permissions: If you have administrative access, check the datamart's permission settings to ensure that your user account or group has the appropriate permissions set. You may need to add yourself as an admin to the datamart.

  4. Documentation and Support: Consult the Power BI documentation for any guidance on datamart permissions and ownership. 
    Sharing Power BI datamarts and managing permissions (preview) - Power BI | Microsoft Learn
    Understand datamarts (preview) - Power BI | Microsoft Learn
    Get started with datamarts (preview) - Power BI | Microsoft Learn

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors