Forum Discussion

Jack_W_KY's avatar
Jack_W_KY
New Member
1 year ago
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 ...
Need Help
Tips and Tricks
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    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/columns

    If 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

v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi @Jack_W_KY ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If 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