Forum Discussion

Kandarp's avatar
Kandarp
Icon for Helper I rankHelper I
3 years ago

Control SQL query in direct query mode

Hi,   I am using Direct Query mode in my power bi report. I have created date table in power bi like below :      I am also using special dates (e.g. Last 7 days, Last Month). So I have c...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Change your implementation.  Maintain your dates table in SQL (table or view), and - ideally- change it to import mode with daily refresh.  There is really no need to recompute that table for every query,