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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate III
Advocate III

"queryinsights" views showing up in sematic models - very difficult to remove

Hi, I'm seeing views from the queryinsights database / schema / whatever it is showing up in the semantic model - things like long_running_queries. Are others seeing this? Image below.


Feels like a bug, and these tables are difficult to remove. Ever after chooseing "delete from default dataset" they sometimes seem to persist. I "could" hide them - but that's a poor workaround.


Just curious if others are seeing this.







Solution Sage
Solution Sage

Yes those new views appear in the Warehouse service in the model tab and then in a report using the default dataset.  I'll be honest and say that I never use the default dataset (semantic model) and always create another dataset specific to the tables/views I want.


And yes, I have hidden them in the default dataset.  Is there any reason why you think this is a poor workaround?  I agree that we should have a choice about if they appear in the semantic model.




hi @AndyDDC , IMO it's a poor workaround just because we have some models with quite a few tables, and it just makes it more difficult when there's additional stuff in the model that isn't even related. I feel like the queryinsights stuff is something new, hopefully Microsoft makes a simple change to not include these in the default semantic model.


p.s. I agree I typically create my own model also.




Community Support
Community Support

Hi @Scott_Powell 


Thanks for using Fabric community.

We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Thanks @v-cboorla-msft I appreciate that!


Hi @Scott_Powell 


Apologies for the issue you have been facing.

This is a known issue.

Making model changes in a Fabric Data Warehouse's semantic model might not work. The types of model changes include, but aren't limited to, making changes to relationships, measures, and more.

The internal team is working to fix this.

Appreciate your patience.

Please refer to this link for more information: Link1


Hope this helps. Please let us know if you have any further issues.



@v-cboorla-msft thanks for the info. I had already tried looking this up on known issues, but apparently the site I was looking at ( ) only shows Power BI known issues. I'll try the workaround and see if it helps.


Appreciate the help!


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.