Query resources Exceeded error

Hi. If it's just columns and it's mandatory the way the table looks. It sounds like you need to reconsider or redesign your data model considering this requirement. That's why it's so important to take the time to build a good start schema with the data. That would prevent this issues. If it's not a column but measure, then reconsider optimizing the code. Read about some ways to optimize engines with SQLBI blogs/videos.

I hope that helps,

Hi lcorbet 

There sometimes can be underlying issues with the Power BI  service which typically get resolved within a few hours. I would recommend trying to test it again tomorrow morning to see if your issue gets resolved. With regards to your error. I would highly recommend looking at the column cardinality and using something like DAX Studio in order to understand which columns are taking up the most memory in your semantic model. And your options are if it is taking a lot of memory, either to remove it as recommended or increase capacity size, or look at different ways to represent the same kind of data.