Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

0
cjfjones

We couldn't load your SQL endpoint

Submitted by on ‎08-03-2023 09:39 AM

Hi,

 

Have started experiencing an issue today, loading the SQL Endpoint view in Fabric.

 

I am still able to consume the data in Power BI, and also through SSMS using the SQL Endpoint, but get the below error when using the Web Interface. I need to update the relationships in the model, and believe this can only be achieved through the SQL endpoint interface in the Lakehouse.

 

Any help appreciated.

 

Activity ID: d41e2f45-3639-4c48-8e12-c3464e05894f
Request ID: 88080a5f-1a86-0fee-d1c1-d06b4103e334
Correlation ID: b51ac36f-dcec-0760-6c69-d4aff3fc33d7
Status code: 0
Time: Thu Aug 03 2023 17:34:38 GMT+0100 (British Summer Time)
Service version: 13.0.21259.51
Client version: 2307.5.15071-train
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

 

 

cjfjones_0-1691080551074.png

 

 

Status: Delivered
See more ideas labeled with:
7 Comments (7 New)
Comments
Anonymous
Not applicable
‎08-03-2023 06:42 PM

Hi  @cjfjones ,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

Anonymous
Not applicable
‎08-15-2023 11:17 PM

Update :

 

A fix for this issue is being deployed and you can retry later.

 

Best regards.
Community Support Team_Caitlyn

jvasaa
Regular Visitor
‎08-17-2023 09:29 PM

Hello, @Anonymous.

 

I am getting the same error "We couldn't load your SQL endpoint" just now:

  • Activity ID8f24deaf-dac1-490b-9495-2b3b19a094a2
  • Request ID18428420-9fdd-a708-ccd3-18234db8413f
  • Correlation IDe54cfdc5-361f-ba95-cefe-4c9d6984a19e
  • Status code500
  • TimeFri Aug 18 2023 07:27:00 GMT+0300 (Eastern European Summer Time)
  • Service version13.0.21310.58
  • Client version2308.1.15207-train
  • Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net/

 

Anonymous
Not applicable
‎08-23-2023 03:19 AM

Hello,

I have the same problem, today 23th of August.

 

Thank you in advance

Best regards,

Barbara

spp-101
Regular Visitor
‎08-24-2023 07:27 AM

@Anonymous  I am also experiencing this issue. Batch was cancellecd with status code 400

 

Any help appreciated.

Screenshot 2023-08-24 133914.png

 

FelixL
Advocate II
Advocate II
‎08-25-2023 02:32 AM

Same exact issue here, today.

 

If I have read/admin permissions on the workspace in which the Lakehouse reside, the SQL endpoint seem to be working properly. But in the cases where access is provided directly (and only) on the Lakehouse artifact (no user view access on the workspace) the SQL endpoint will not load correctly.

 

However, if the user who has gotten the Lakehouse artifact shared (but no workspace read access) in turn create its own Lakehouse in its own Private Workspace it can successfully create shortcuts to the tables tables in the original Lakehouse, and successfully use the SQL endpoint in its own Private Lakehouse.

 

This is fully (100%) reproducable with multiple user accounts and newly created workspaces and lakehouses. 

 

FelixL_0-1692955922706.png

 

Anonymous
Not applicable
‎08-31-2023 01:27 AM

Thank you Felix,

my colleagues seem to confirm your point, we have to test it exactly.

Idea Statuses