Forum Discussion
Direct query is excessively slow
Hi Mentors; I am building a report and this needs immediate data; Hence I am using direct query over a table valued function as there are lots of logics need to be implemented. Now in the query, I h...
Hi Stephen,
Thanks for your reply. I have already gone through the link. However, this is not working in DirectQuery while published to Service. This is the main issue.
However, I am found a workaround. Initially I was using the "Table Valued Function" and THIS WAS THE CAUSE OF SLOWNWSS. Now I have inserted the data in a physical table and so far the performance is satisfactory.
So, my learning is not to use TVF unless this is the only solution.
Regards,
Arup
Hello Mentors,
Is there any solution for this or thisis NOT possible so far in PBI?
Regards,
Arup