Power Platform Community Forum Thread Details

Hi everyone,

I'm hoping someone has come across this issue before.

Environment

Power BI Service / Fabric Workspace

Workspace assigned to Fabric Capacity (F2)

Semantic Model: Sales Performance

Power Automate Flow used by a Copilot Studio Agent

Action used: Run a query against a dataset

Problem

A flow that was working successfully a few weeks ago suddenly stopped working.

The Power Automate action returns:

DatasetExecuteQueriesError

Failed to open the MSOLAP connection.

AnalysisServicesErrorCode: 0

Full Error:
{

"code": "DatasetExecuteQueriesError",

"details": [

{

"code": "DetailsMessage",

"detail": {

"value": "Failed to open the MSOLAP connection."

}

},

{

"code": "AnalysisServicesErrorCode",

"detail": {

"value": "0"

}

}

]

}
What I've investigated so far

Power BI Workspace
- I am a Workspace Admin.
- Other Workspace Admins are also unable to access the model properly.
- Taking ownership of the semantic model did not resolve the issue.
Semantic Model

When checking Semantic Model Settings, I initially received the warning:

"One or more cloud data sources for this semantic model have been deleted."

The semantic model contains a SharePoint source:

SharePointList(

https://<tenant>.sharepoint.com/sites/powerbi/

)
`
I remapped the source to a Personal Cloud Connection and saved the changes.

Additional Findings
- Data Source Credentials section is unavailable/greyed out.
- Scheduled Refresh is disabled.
- Refresh History only shows successful refreshes (no obvious failures).
- Opening the Semantic Model sometimes shows an empty model with no visible tables.
- Execute Queries API continues to fail after remapping the SharePoint connection.
Tested

✅ Workspace Admin permissions confirmed

✅ Semantic model ownership transferred/taken over

✅ SharePoint cloud connection remapped

✅ Issue reproduced by another Workspace Admin

❌ Power Automate "Run a query against a dataset" still fails

❌ Copilot Studio Agent still fails

❌ MSOLAP connection cannot be opened

Questions
1. Has anyone seen AnalysisServicesErrorCode = 0 with an MSOLAP connection failure before?
2. Could deleted/recreated SharePoint cloud connections leave a semantic model in a broken state?
3. Is there a way to rebuild or restore semantic model bindings without recreating the model from the original PBIX?
4. Are there diagnostics I can run to confirm whether the issue is the semantic model itself rather than user permissions?
Any suggestions would be greatly appreciated.

Thanks!