Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am currently building a BI using direct query.
In the report, there is a visual table containing 20K rows each day.
However, for this report, the first day it takes 15-20 sec to run and after 3 months, it is taking 60 sec.
And sometimes it shows "out of resource" error.
May I seek any advice to this. I have been trying to modify the model but it doesn't really help.
should I modify on the source? and how?
Can you provide screenshot?
User | Count |
---|---|
90 | |
73 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
73 | |
60 | |
58 |