topic Data Warehouse from sample no longer loading: "We couldn't load your warehouse" in Data Warehouse

Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

dphugo — Sat, 17 Jun 2023 18:37:45 GMT

I created a Warehouse using the "Sample Warehouse" option.

I was able to browse, query and connect to it from SSMS.

Since a few days ago, when I click on the Warehouse it loads the loading screen with "Loading your warehouse", I now get the following error message and cannot proceed.

I can also no longer connect to the Warehouse using SSMS.

What's my next option to resolve this?

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

Anonymous — Fri, 23 Jun 2023 14:27:50 GMT

Hi dphugo I am unable to reproduce this issue are you still facing this issue?

Regards

Geetha

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

rocketporg — Fri, 07 Jul 2023 13:33:54 GMT

I've had this error several times, although it appears to happen randomly. Only way I've found to deal with it is to delete and re-create the warehouse. I'm guessing this is just some teething issue as its still in public preview. Hopefully it won't happen when Fabric goes GA

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

mdgandhi07 — Thu, 20 Jul 2023 19:30:23 GMT

I am facing similar issue. Unable to open any warehouse. I am using Edge on Windows10 and this has been happening since last week.

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

dphugo — Fri, 21 Jul 2023 06:30:12 GMT

Hi Anonymous. Yes, I still get this error when trying to open the Warehouse.

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

Anonymous — Tue, 01 Aug 2023 15:05:48 GMT

Hi all, i am encountering the same issue using the trial capacity F1 within central europe region. The issue started after generating a date table for 25 years in the warehouse.

Imho it's not serious, sovilng this problem by re-creating the warehouse. Especially when not having any copy of the metadata -:)

Any ideas?

Best, Otti

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

dphugo — Wed, 02 Aug 2023 09:13:59 GMT

Let's hope this gets fixed before GA. In my context a Data Warehouse is Enterprise wide, daily refresh from dozens of sources, with considerable amount of dashboards, reports and campaigns running daily. So dropping and recreating a Warehouse is not feasible.

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

dBI — Fri, 04 Aug 2023 20:40:02 GMT

Ran into this as well. Tried a day later, did not load. Deleted the DW and recreated, did not load. Deleted the workspace, recreated a new DW and it did not load.

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

JaimeVasquezOMC — Fri, 25 Aug 2023 02:51:58 GMT

This is also happening to me, Im trying to implement a proof of concept for a customer to convince him that this is a good option for them. Seems not that optimal to get these errors right from the start.

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

DataPne — Tue, 29 Aug 2023 13:21:11 GMT

We are also having this error on our end quite frequently, and honestly the speed of the warehouse is not magnificent. Had to filter down the data in all tables to 200 rows just to be able to create a mock-up in PBI prior to it crashing on me.

Anonymous any word on microsoft flagging this as an issue?

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

jochenj — Wed, 15 Nov 2023 15:26:15 GMT

same here, DWH stopped working , no more accesable via PBI-UI or SSMS (SQL Endpoint). Wish we could at last more info in the error details beside StatusCode=500

Learning: Always store a backup of your tsql code for procs/views you created in the DWH, otherwise you will loose your work 😞

Re: Data Warehouse from sample no longer loading: "We couldn't load your warehouse"

AndyDDC — Wed, 15 Nov 2023 15:44:18 GMT

Hi jochenj yeah it's a pain to be sure. You can use Azure Data Studio with the Database Projects extension to source control a Fabric Warehouse now.