Creating & Changing Tables in Power BI Desktop with Tabular Editor
When connected to a Remote PBI XMLA Endpoint you can add new tables and change existing ones However if you are connected to a local Power BI Desktop Session you cannot make this work.
Open a new Power BI Model and add data to a table. Save the PBIX
Open TE and connect to the PBI Session
Duplicate the table or add a new one.
Power BI Shows the new table but also shows the message - There are pending changes in your queries that haven't been applied. Apply changes / Discard Changes
Apply Changes - Erases you changes from TE and removes the table.
Discard Changes - Does not work and the message remains.
It would be a very useful to be able to di this, especially for those of use who are using TE against PBI Premium models where you can no longer download the PBIX data model after implementing incremental refresh or editing the model via XMLA.