Forum Discussion
Solved
DATE_DIM tables and Direct Query
In my org, we default all cloud data sources to direct query. My group is sourcing our data in Snowflake sitting on Azure. We need to use date heirarchy logic in several reports we've built and we ...
Hi Jack_W_KY ,
You can try these approaches-Run Query diagnostics in Power BI desktop
Go to: Tools > Query Diagnostics > Start Diagnostics
Check logs for steps that take too long
If you see long durations between “Data retrieved” and “Data displayed” — it's not Snowflake, it’s post-processing or service-side bottleneck
Try:
1.Temporarily using Import Mode for DATE_DIM Only (if Composite Models are enabled)
2.Move DATE_DIM into Snowflake
3.Reduce number of visuals, filters, bookmarks
4.Test different gateway config
5.Reduce result set by limiting rows/columnsIf the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
