PowerBI and Reflections

Hello, guys! Have you ever noticed how complex PowerBI generated queries are? They have lots of apparently unnecessary sub-queries, CASTS and conversions, specially on WHERE clauses.

I seem to have noticed that these kinds of CASTS start to make aggregation reflections less useful than they really are, do you guys believe this is really the case? Do you have any kind of known “problems” on queries (made by PBI or not) that make them less performatic?

@mendeel

This can happen, often PowerBI and Tableau should have settings that help avoid these. Have you checked with PowerBI support?