Forum Discussion
Helper IDirect Query - Time Function - Slow Performance
Hello,
Topic may be closed, biggest issue was with masking at snowflake level - my other topic:
https://community.fabric.microsoft.com/t5/Desktop/SnowFlake-Direct-Query-Slow-Perfomrance-Adding-Role-at-Power/m-p/4811141#M1430972
When solving this issue, metric started to work correctly again. Thanks all for help, learned a lot.
Super UserDirectQuery is always slower than Import
Your DAX is OK but performance in directquery depends on the source structure, internet connection and so forth
Why not using Import instead of DirectQuery?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI