Is it better to use a native query for when my group by breaks query folding

[akhaliq7]

Is it better to use a native query for when my group by breaks query folding

[v-jingzhang · Accepted solution]

Hi @akhaliq7 

If your group by breaks query folding, you can use Group by statement in a native query to query the same data source. For example, SQL Server GROUP BY  and Oracle GROUP BY 

You can also create a view with Group By in the database in advance, then connect your Power BI report to the view.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.