Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

HIlTes

Not possible to delete tables in datamodel: Failed to save modifications to the server (desktop)

Submitted by on ‎11-05-2024 02:11 AM

Not possible to delete tables in a Power BI semantic model. Returns following:
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.137.1102.0","ModuleName":"Microsoft.PowerBI.Modeler.dll","Component":"Microsoft.PowerBI.Modeler.TomExtensions","Error":"Microsoft.PowerBI.Modeler.ModelingASOperationException","MethodDef":"ThrowAsModelingASOperationException - PFE_CRASH","ErrorOffset":"17","ErrorCode":""}

Can not delete measures, tables or anything - keeps failing. When I try to delete from the query editor and apply the change it says:

Model queries
Failed to save modifications to the server. Error returned: 'Cannot find table 'Xxx'. Cannot find table 'Xxx. Cannot find table 'Xxx. An unexpected exception occurred. '. The table is available and can be refreshed. 
Status: Investigating

Hi  @HIlTes ,

 

The error message you're seeing, "Cannot find table 'Xxx'," suggests that the table might be missing or not properly referenced in the model. This can occur if there are issues with the schema or if the table was deleted or renamed outside Power BI, but you can review the applied steps for each query in Power BI desktop to see if there have been any changes to the schema. Look for steps that add, remove, or modify columns and tables and ensure the changes are correctly applied.

You may aslo make sure that all necessary permissions are granted for the data sources and that there are no schema changes that might be causing the issue.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎11-05-2024 06:52 PM
Status changed to: Investigating

Hi  @HIlTes ,

 

The error message you're seeing, "Cannot find table 'Xxx'," suggests that the table might be missing or not properly referenced in the model. This can occur if there are issues with the schema or if the table was deleted or renamed outside Power BI, but you can review the applied steps for each query in Power BI desktop to see if there have been any changes to the schema. Look for steps that add, remove, or modify columns and tables and ensure the changes are correctly applied.

You may aslo make sure that all necessary permissions are granted for the data sources and that there are no schema changes that might be causing the issue.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses