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!

Remove direct query table in PBI desktop

I've added a dataset to my model in PBI desktop for test reasons. Now I want to remove the table but there is no option to remove it (e.g. in the context menu as for all other tables). I then removed the dataset in PBI service to force PBI to let me remove the table. But this all doesn't work.
So, how do I remove the table from my model?

Status: New
Comments
Patrick_Taggart
New Member

Hi @fwde 

 

Brilliant. Thank you! 

 

I also found this helpful video after I posted this. 

 

https://www.youtube.com/watch?v=kufhOFPaQ4U

 

Glad they got that one resolved. I am sure I was one of millions people that had messed up a previously good model by bringing in a direct query dataset and then having to awkardly hide it since I could not remove it.