
How do you handle schema refreshes for Import models?
I have an Import mode model pulling from a Lakehouse SQL Analytics Endpoint, and a new column was recently added upstream.
According to the official documentation, "Changes in data source table structure, or schema, such as a new, renamed, or removed column can only be applied in Power BI Desktop."
Because of this limitation, I currently have to manually open the .pbix in Desktop, refresh to pull the new column, and republish.
How are you all automating this in production so you don't have to open Desktop?
- Can this be done easily with Tabular Editor via CLI or other means?
- Has anyone used semantic-link-labs to force a schema sync for Import mode?
- Are there any other tricks you use to handle schema drift?