Semantic Model Take Over Error

[kasun_rumesh]

One of our employees created a semantic model using one of our data sources. He has since left the company, and his account has been removed. After that, I took over the semantic model. After taking over, I’ve been receiving an error. When I try to enter the credentials for the data source, the option appears disabled. Both the former employee and I have Admin access to the workspace. How can I resolve this issue?

[v-ssriganesh · Accepted solution]

Hi @kasun_rumesh,
Thank you for reaching out to the Microsoft fabric community forum.

The issue may be related to the ownership transition. Here’s how you can resolve this:

• Confirm your Admin role is fully updated in the workspace settings, as the former employee’s account removal might have caused a permission conflict.
• In the Power BI Service, go to the workspace, locate the semantic model, click the ellipsis (three dots), and select "Take over" to ensure you’re the official owner.
• Navigate to the semantic model settings in Power BI Service, and under "Data source credentials," try to update the credentials manually. If the option remains disabled, it might be tied to a gateway or ownership issue.
• If the above doesn’t work, you may need to remove the existing data source in the semantic model settings and add it again using your credentials.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hi @kasun_rumesh,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @kasun_rumesh,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh · Accepted solution]

Hi @kasun_rumesh,
Thank you for reaching out to the Microsoft fabric community forum.

The issue may be related to the ownership transition. Here’s how you can resolve this:

• Confirm your Admin role is fully updated in the workspace settings, as the former employee’s account removal might have caused a permission conflict.
• In the Power BI Service, go to the workspace, locate the semantic model, click the ellipsis (three dots), and select "Take over" to ensure you’re the official owner.
• Navigate to the semantic model settings in Power BI Service, and under "Data source credentials," try to update the credentials manually. If the option remains disabled, it might be tied to a gateway or ownership issue.
• If the above doesn’t work, you may need to remove the existing data source in the semantic model settings and add it again using your credentials.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[kasun_rumesh]

I have tried all the things you mentioned in there. I'm stuck in Data Gateway part.

[v-ssriganesh · Accepted solution]

Hi @kasun_rumesh,

Thank you for the update. Please consider the below steps:

• In Power BI Service, go to "Gateway and cloud connections" in the workspace. Ensure the gateway is listed as "Online." If not, confirm the on-premises data gateway is installed and running on the server.
• The gateway might be tied to the former employee’s account. In Power BI Service, go to "Manage gateways" (you may need admin portal access). Verify you’re listed as a gateway administrator; if not, add yourself.
• In "Gateway and cloud connections," locate the data source for the FactSales semantic model. If it uses the former employee’s credentials, remove and re-add it with your credentials, then re-map it to the gateway and test the connection after reconfiguring. If it fails, check credentials, server details, or firewall settings.
• If the data source doesn’t need a gateway, remove the gateway association and set it up as a cloud connection.

If this information resolves your issue, please “Accept as Solution” and give a "Kudos" to help other community members.
Thank you.