Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Creating & Changing Tables in Power BI Desktop with Tabular Editor

Creating & Changing Tables in Power BI Desktop with Tabular Editor

 

Hi,

 

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.

  1. Open a new Power BI Model and add data to a table. Save the PBIX
  2. Open TE and connect to the PBI Session
  3. Duplicate the table or add a new one.
  4. 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
  5. Apply Changes - Erases you changes from TE and removes the table.
  6. 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.

 

Thanks

 

Toby.

Status: New
Comments
v-lili6-msft
Community Support

hi  @thedatacrew 

To my knowledge, it may couldn't achieve for now.

for your requirement, you submit your idea in here to make it coming soon.

 

Regards,

Lin