Forum Discussion
How have the calculated table refresh when the direct query table re-queried
I have been uing Power BI since before it went General Availablility and build hundreds of models. So far, I have only seen ONE real case that required DIRECT QUERY. Yet I see all kinds of threads from people asking how they can make Direct Query work.
Please take a step back and ask yourself, or your business users: "What is the business requirement for having Direct Query (in other words, REAL TIME) data?" And: "Can you live with, say, hourly refresh throughout the day?"
If they absolutely insist on DQ, then do that, but also spin up a Usage Metrics report in the Workspace where the model is deployed and watch it over the next few days, weeks, months. After three months you will probably find that usage has tailed off and people are looking at it once a day.
I know that's not an answer to your question, but I really think it needs to be mentioned.