Forum Discussion
Identical semantic models, but only one has an error
Hi JrBIAnalyst
please try below points.
In your PBIX file, temporarily add back the removed column, even if it's just a dummy or blank column with the same name and type. Then, publish the file again using the exact dataset name to replace the old one. This should allow the Service to accept the publish without errors, as the schema will match what is expected. Once everything is stable, you can use Tabular Editor or the XMLA endpoint to safely remove the unused column from the dataset object, preventing issues with downstream reports.If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Thanks.
Super UserIN the minor changes you made to the semantic model, did you cancel any column or table?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Yes, I did remove a column. But the underlying issue is that for some reason, having removed the column results in the data model no longer publishing correctly. That's the part that I really need help with. Given that I can't delete the data model because of its downstream use, how do I force the new model to publish correctly?