Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am trying to change the account for a semantic file to a service account from my account.
I get the following error.
Failed to update data source credentials: AnalysisServices: The specified Power BI workspace is not found.
You need to use SSL (HTTPS) when you use OAuth 2.0 authentication.
Some of my semantic files can be changed and others can't
Solved! Go to Solution.
Hi @djm7,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Thank you @Deku, for your insights.
The issue you're encountering is likely due to hosting semantic models in My Workspace, which is a personal workspace tied to your individual account. This setup is not suitable for service accounts, as they cannot reliably access or manage resources within another user's personal workspace—hence the "workspace not found" error when attempting to update credentials.
Additionally, the error referencing OAuth 2.0 and SSL indicates that the Analysis Services connection is using an insecure (HTTP) endpoint, which is not supported with OAuth authentication. I recommend moving the semantic models to a shared Power BI workspace where you can assign the service account a Contributor or Admin role.
Also, ensure that the Analysis Services connection string uses HTTPS, and verify that the data gateway is properly configured if you're connecting to on-premises sources. This approach will allow the service account to manage credentials as expected and aligns with Power BI best practices for enterprise deployments.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @djm7,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.
Hi @djm7,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Thank you @Deku, for your insights.
The issue you're encountering is likely due to hosting semantic models in My Workspace, which is a personal workspace tied to your individual account. This setup is not suitable for service accounts, as they cannot reliably access or manage resources within another user's personal workspace—hence the "workspace not found" error when attempting to update credentials.
Additionally, the error referencing OAuth 2.0 and SSL indicates that the Analysis Services connection is using an insecure (HTTP) endpoint, which is not supported with OAuth authentication. I recommend moving the semantic models to a shared Power BI workspace where you can assign the service account a Contributor or Admin role.
Also, ensure that the Analysis Services connection string uses HTTPS, and verify that the data gateway is properly configured if you're connecting to on-premises sources. This approach will allow the service account to manage credentials as expected and aligns with Power BI best practices for enterprise deployments.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
the service account is an admin on the production folder where the primary report is located
Hi @djm7,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @djm7,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
all of my test semantic models are in My Workspace. Some of the semantic model can be changed to the service account and others can't.
From the error it like you may be using the analysis services connector? Are those other models in a different workspace? Does the account have access to these?
The service principal or account would need to be at least contributor in the workspace
User | Count |
---|---|
47 | |
31 | |
28 | |
27 | |
26 |
User | Count |
---|---|
58 | |
55 | |
36 | |
33 | |
28 |