topic Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI in Data Engineering

Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

Anonymous — Mon, 16 Oct 2023 16:18:07 GMT

As of 2pm today +/- my SQL queries are not working when run from SSMS . They were working fine before. They also fail when I refresh my power BI model with the following error. This seems to be a bug as they were working last week .

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. An unexpected exception occurred.

Thanks

Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

HimanshuS-msft — Mon, 16 Oct 2023 17:30:54 GMT

Hi @Anonymous

Thanks for using the Fabrics community .

As you mentioned that the things did worked fine last week and I am assuming that nothing much has changed since then , I will request you to please go ahead with Microsoft support on this . https://support.fabric.microsoft.com/en-US/support/.

Also once you have opened the support ticket , please do share the supportcase# here ,

Thanks
HImanshu

Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

Anonymous — Wed, 18 Oct 2023 11:19:15 GMT

Hi @Anonymous ,
Did you get a chance to raise a support ticket?
If yes can you please share the details here as it would be helpful for us to track further for more information.
Thank you.

Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

Anonymous — Wed, 18 Oct 2023 11:42:20 GMT

Hi - I didn't raise a support ticket because it started working again soon after I posted this message

Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

Anonymous — Wed, 18 Oct 2023 12:19:29 GMT

Hi @Anonymous ,
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.

Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

Anonymous — Thu, 19 Oct 2023 08:53:53 GMT

Support request number: 2310180050003825

Re: Fabric Lakehouse SQL endpoint running forever when queried from SSMS and Power BI

Anonymous — Thu, 19 Oct 2023 09:31:31 GMT

Hi v-nikhilan-msft

I did raise a support ticket and its being looked into. No soulution so far

Support request number: 2310180050003825

Thanks