SQL Query is NOT running in Fabric Warehouse.

[Anonymous]

I'm receiving below error when run a query in Data Warehouse of Fabric.

Note: This is happening if the browser tab is ideal for couple mins and if we refresh the browser table then the query is working fine.

Activity ID: ba697533-92fe-48f2-8ce8-177bd4de8f47
Request ID: ceacd5ac-c747-e346-e39f-6dad15f4cfb0
Correlation ID: f08f508e-6bba-764c-5319-109edcc7f463
Status code: 401
Time: Thu Sep 14 2023 16:54:00 GMT-0500 (Central Daylight Time)
Service version: 13.0.21509.81
Client version: 2309.1.15569-train
Cluster URI: https://wabi-west-us3-a-primary-redirect.analysis.windows.net/

[Anonymous]

Hi @Anonymous ,

Thank you for your respose.

If the session is ideal for couple mins any query is NOT running and throwing as error (sent you the screenshot in inital message).

But after doing a hard refresh of the webpage then the query is running.

I appreciate you provided work arounds but why the query is not running if my session is ideal for couple mins.

I can't refresh the page everytime.

I'm providing a screenshot of a query which I just ran.

[Anonymous]

Hi @Anonymous ,

Thanks for using the Fabric community and reporting this . 

I have reached to the internal for help on this. I will update you once I hear from them.

In mean time can you please share in which region you are working and facing this issue?

[Anonymous]

Hi @Anonymous ,

I'm using Microsoft 365 E5 Developer trail subscription from US location.

[Anonymous]

Hi @Anonymous ,
Apologies for the delay in reply from our side. Did you got a resolution for this?

If you are still facing this issue could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details,
 

Email subject: <Attn - v-gchenna-msft  : SQL Query is NOT running in Fabric Warehouse.>

Thread URL: https://community.fabric.microsoft.com/t5/General-Discussion/SQL-Query-is-NOT-running-in-Fabric-Warehouse/td-p/3431898

HAR file: 

Please follow this link inorder to understand how to collect HAR file.

[Anonymous]

Hello @Anonymous ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[Anonymous · Accepted solution]

Hi @Anonymous ,

my apologies for delayed response.

I really appreciate you checking with me.

Today, I didn't get his error (I haven't done anything).

I'll send the email if get this error again.

Again, I appreciate you for checking and helping me.

[Anonymous]

Hi @Anonymous  - Thanks for your response.

Glad to know your issue got resolved. This issue was an intermittent issue, checked with Internal Team and  got a confirmation that this issue no longer exists.

Please continue using Fabric Community for help regarding your issues.

[Anonymous]

Hi @Anonymous ,
Welcome to Microsoft Fabric platform and thanks for posting your question here.
As I understand that you are trying to execute queries in Fabric Warehouse, but facing issue when browser tab is ideal for couple of mins.

When I tried to repro the scenario, I am able to execute the query in Fabric Warehouse even after 1 hr of ideal period.

Could you please share in further details like what query you are trying to execute and region you are trying to use Fabric.

You may try the following steps and let us know.

1. Clear “Cookies and Cached data” of your browser.

2. Private Mode (New InPrivate Window).    

3. Try in different browser.

Hope this helps.