Forum Discussion
SQL end point not querying or execute commands.
I really need help guys.
My workspace in fabric just won't load and do anything.
I try to preview a table. it stucks on loading screen.
and select top 100 won't work either.
It doesn't matter what table or view I choose, I can't query or preview anything.
This morning everything works again! Although nor my IT or Microsoft Support has done anything.
For those who are interested what happened during that time:- Created ticket with our Unified Support Contract to Microsoft. No end resolution given, only suggested to restart capacity.
- Created ticket in our company's IT to restart capacity. Not carried out, due to possible impact on other workspaces- Our IT suggested to increase capacity, but haven't done it yet.
It seems magically solved it self after 5 days of waiting and stress.
6 Replies
This morning everything works again! Although nor my IT or Microsoft Support has done anything.
For those who are interested what happened during that time:- Created ticket with our Unified Support Contract to Microsoft. No end resolution given, only suggested to restart capacity.
- Created ticket in our company's IT to restart capacity. Not carried out, due to possible impact on other workspaces- Our IT suggested to increase capacity, but haven't done it yet.
It seems magically solved it self after 5 days of waiting and stress.
Hi, Anonymous
After my testing, the SQL endpoint query is fine, as shown in the following image:
In your interface, your queries don't seem to stop, as I tested below:
You can check if your steps are correct according to the following documents:
Query the SQL analytics endpoint or Warehouse - Microsoft Fabric | Microsoft LearnIf your dataset is large, then your patience is required. In my test, when the query is complete, the corresponding table is returned. It also depends on the data source you use, the network situation, etc.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
Thank you very much for your reply. Listening to your description, your dataset is really small and shouldn't have the problem of not loading at the moment. You can ask your question in your ticket to get a solution. You are also welcome to share your workarounds here and mark them as solutions so that others in the community can quickly find answers to similar problems. Thank you again.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.