Forum Discussion
Fabric Workspace - Semantic Model - Fabric Warehouse - Model Update Issues
Thanks for any input.
As an update I have sorted myself, in realising that the Semantic Model had added to it in a current iteration of development an aliased table following a migration approach from a on-premise solution and that you can't operate with aliased tables in Direct Lake models and they need to physicalized - in my case in the Fabric Warehouse.
I worked this out through a process of elimination and after deleting the aliased reference from the model I had no issues.
The error occurs because your custom Semantic Model is out of sync with the updated Fabric Warehouse schema likely due to duplicated or ambiguous column references. To fix it, open the model in Power BI Desktop, remove and re-add the affected tables to refresh metadata, and check for duplicate column names in the warehouse using INFORMATION_SCHEMA.COLUMNS.
Thanks for any input.
As an update I have sorted myself, in realising that the Semantic Model had added to it in a current iteration of development an aliased table following a migration approach from a on-premise solution and that you can't operate with aliased tables in Direct Lake models and they need to physicalized - in my case in the Fabric Warehouse.
I worked this out through a process of elimination and after deleting the aliased reference from the model I had no issues.