The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am currently building out a report that uses Query Parameters with Direct Query.
I noticed that my report is running awfully long. I ran the Performance analyzer and there’s one table thats taking soo long!
What are some suggestions to help this?
Btw it’s not on the database side. We tested by selecting a value from the filters to fire off the database and it finished within seconds. So it’s on the power bi side.
I need suggestions!
@Chanise89 , Make sure there are no bi-directional join
And you have index on join columns in database
Not using any complex views
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |