Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am having trouble when using a SQL database in Fabric - it is taking a very long time to complete queries.
For example, when selecting all rows (<10) from a table with less than 10 columns, it is taking 40 seconds to complete:
I can see that the query execution time itself is very quick, but there seems to be a 20 second buffer before and after the query is completed.
A similar thing happens when perform other operations, such as creating/altering a stored procedure, inserting/deleting records - always around 40 seconds to complete.
For reference, I am currently operating on an F2 capacity. I sometimes find that when I first complete such a query on a given day, it will run quickly, but any subsequent queries are very slow (as above).
Is this a capacity issue, or perhaps expected behaviour?
Thanks 🙂
Solved! Go to Solution.
Hi @JamesMurkin1 , sorry to hear about the slow experience. Could you please create a support ticket and provide your Fabric Tenant, Workspace and Database ID information in the supporte request for our support team to look at the telemetry to help troubleshoot. It could be an F2 capacity as it might be throttling but 10 rows returning for 10 cols in 40s is not normal and not expected behavior. Appreciate your patience and support.
Hi @JamesMurkin1 ,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue through support or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.
Hi @JamesMurkin1 , sorry to hear about the slow experience. Could you please create a support ticket and provide your Fabric Tenant, Workspace and Database ID information in the supporte request for our support team to look at the telemetry to help troubleshoot. It could be an F2 capacity as it might be throttling but 10 rows returning for 10 cols in 40s is not normal and not expected behavior. Appreciate your patience and support.
Hi @idrismotiwala.
Thanks for the suggestion - I have raised a support ticket accordingly. I will respond to this thread with any response/solution that is provided.
Thanks 🙂