Forum Discussion
DataMart Change Table Structure
Hi there I am refreshing a DataMart and am receiving an error because I have added a new column to the table. How do I handle this? This is the error: " Local Sql execution failed. Messa...
Hi v-yanjiang-msft - appreciate you responding, but I don't think you are understanding the question. Power BI creates the tables behind the scenes - we don't. (Imported) Tables will definitely change structure over time, and the datamart needs to account for this. Please pass this along to the product team. This same situation will happen in a regular database, but we don't have full control over the back-end db associated with the datamarts in Power BI, do we?
Thank you,
-hauffa
Hauffa's comment is correct! We don't have permissions to alter table ourselves and the documentation is not clear.