Can't open the "edit tables" when I'm editing an online model connected to a warehouse

[Jerome22]

Hi,

suddenly I can't open the edit tables dialog box to add or remove tables to an online model.

worked yesterday, now the dialogbox is not displayed at all. so I can't add or remove any tables in my model anymore!

I tried with 2 computers and 2 browsers, same result.

more details:

this impacts 1 semantic model connected to a data warehouse

I tried another existing model connected to the same warehouse and this second model return an empty list of tables:

(I'm supposed to see about 100 tables)

I can edit the tables from models connected to a lakehouse.

so the problem appear to be related to warehouses only with 2 different behaviors (no dialog box or empty one).

any idea?

edit:

when I click "refresh" on the empty dialog box, I receive this message:

We could not refresh your warehouse schema

The datamart data is invalid

[v-yajiewan-msft]

Hi @Jerome22,

According to our internal notification, the fix for the issue has been deployed.

We kindly ask you to check and confirm if the issue has been fully addressed on your end.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jerome22]

Hi,yes apparently the fix has been deployed (at least for me)

[pdbenbow]

Same here, I noticed the fix appeared a few days ago. Much better!

[v-yajiewan-msft]

Hi @Jerome22, 

This issue has been confirmed as a known issue internally.

Please be patient to wait for fixing. If there is any news, I will update it here.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jerome22]

yep

MS just confirmed to me that the solution will be deployed the 07/09/2024 to all the regions.

so apparently they found the problem and the solution.

and there is no workaround for now.

[Neustupa2001]

We are experiencing the same thing on our team.  It is not the default model and we've tried multiple accounts, browsers and computers.

[pdbenbow]

I'm seeing the same behavior.

[BenMcC]

My team is experiencing the same issue noted in this thread. Additionally, source control is failing to load the Warehouse with the following error. Restoring the warehouse to even prior to the last successful commit didn't help. 

Workload Error Message An object with name '{{Relationship_Name}}' already exists in the collection.

[pdbenbow]

The other behavior I'm seeing with this feature is this:

- Open the data model

- Click "Edit tables"

- The dialog appears on the screen for a brief moment and then immediately disappears before I can interact with it.

[Jerome22]

excatly my problem too.

I was on a call with microsoft, they saw all these problems replicated and I mentioned that I'm not alone with this problem.

[Jonvoge]

Is it by chance the default semantic model for the Warehouse? As far as i know, those can only be edited from inside the Warehouse Model tab.

If it is not the default model, then of course disregard this suggestion.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[pdbenbow]

Same situation for me. This is a non-default model I created in the same workspace as the data warehouse it is connected to. 

[Jerome22]

Hi,

it's another model, not the default one.

I was able to reproduce the problem by creating a new model, after the initial creation, I can't edit the tables anymore.

I opened a ticket with Microsoft.