Error fetching data for this visual - Report with Direct Query to Lakehouse

Hey all, I'm hoping someone on here may be able to help me. I've already entered a ticket and been in a back and forth with them but getting nowhere 😞. 

On a daily basis, I have a few reports that I will go into where the visuals are all errored out. The detail of the error message says "Error fetching data for this visual. Failed to complete the command because the underlying location does not exist." Then it has the specific table and a few other details.

Here's the crazy part - the table exists in the lakehouse AND when I view the table in the lakehouse (pull it up to see the rows of data), it works fine. EVEN WEIRDER - I can then go back to the report, refresh the visuals and it all works fine!!! This is a workaround that I found even before I put the support ticket in. The crazy part is that the table that is mentioned in the report is my date table and it's refreshed weekly but the error happens daily. On occassion, I do see the error for other tables. The same workaround works. Those tables tend to be refreshed daily or more frequently.

What's even more weird - this same exact table is accessed in many other lakehouses and many other workspaces that don't have this issue at all. It's isolated to a few workspaces (less frequently used) and their lakehouses and reports...

ALL of the tables that are mentioned in the error messages are used in other workspaces and many other reports which do not exhibit this behavior.

More on my structure:

The report pulls data from a Lakehouse using direct query. The table is a shortcut to another workspace where I manage the data that comes in. I've built out a medallion architecture and then create a lakehouse for each user group in their own workspace. The lakehouse in the user's workspace links back (via shortcut) to a lakehouse that I use to serve the data - it basically is a bunch of shortcuts back to the most refined version of each table. The date table that is usually the issue is created in a notebook and saved in a lakehouse.

The date table shortcut goes back to the lakehouse where the data is actually stored.

The other table shorcuts go back to a lakehouse which has a shortcut to the data warehouse where the data is stored.

We have an F64 sku. I've built up a bunch of pipelines to process our data and provide it for reporting. I've been using Fabric since it was in preview.

For the date table, that means:

Shared Tables Lakehouse --|new workspace|-> End User Lakehouse (via Shortcut to the Serving Lakehouse) ---> Semantic Model via direct query

For most of my other tables, this means:

Staging LH ---> Raw Datawarehouse ---> Clean Datawarehouse ---> Refined Datawarehouse ---> Serving Lakehouse (via shortcut to DW) --|new workspace|-> End User Lakehouse (via Shortcut to the Serving Lakehouse) ---> Semantic Model via direct query

What I've tried:

• Deleted and recreated the shortcut - didn't work
• Deleted and recreated the lakehouse - didn't work
• Rebuilt the Semantic model - didn't work
• Submitted a support ticket to Microsoft
  • They escalated to the PG team after some troubleshooting
  • The PG team told the tech support team that my users and I just have to go into the lakehouse each time, pull up the table, then refresh the data in the report 😳 (Which I reminded them is the workaround I told THEM about and isn't a solution because it really shouldn't work this way and doesn't in other places)

I'm trying to avoid completely recreating the Workspace. I'm also trying to avoid copying the data from the source lakehouse to the end user's lakehouses - that would undermine the value of Fabric.

Has anyone else seen this and, if you have, found a fix?