SQL end point not querying or execute commands.

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[Anonymous]

Hi, @Anonymous 

Thank you very much for sharing.

Best Regards

Jianpeng Li

[Anonymous]

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 Learn

If 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.

[Anonymous]

Thanks for trying it out on your end. Unfortunately for me, it is only a table with 1000 rows, less than 10 columns. The whole warehouse is less than 2 MB.

I created a support ticket with our Unifiend Support Contract. I hope to solve this with Microsoft support team soon.

[Anonymous]

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.

[Anonymous]

Just checked , it is still running and not loading anything.