topic Re: Semantic model on warehouse: Field list item has errors in Data Warehouse

Semantic model on warehouse: Field list item has errors

cw88 — Thu, 22 Feb 2024 08:38:43 GMT

Hi,

since monday or tuesday i get the following warning for every table in all semantic models:

Nothing has changed on the warehouse. I cannot find more.

at first glance, everything seems to work fine...

Does anyone have an idea what it could be?

Thanks!

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Thu, 22 Feb 2024 08:54:42 GMT

Hi cw88 ,

Thanks for using Fabric Community.
Can you please share the location you are observing this error? So that I can check and guide you better,

Re: Semantic model on warehouse: Field list item has errors

cw88 — Fri, 23 Feb 2024 08:40:24 GMT

Location is West Europe

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Fri, 23 Feb 2024 08:50:55 GMT

Hi cw88 ,

Inorder to check the issue at my end, can you please tell the steps?
If possible please share the complete screenshot. I would like to know where you are seeing this error.

Thank you

Re: Semantic model on warehouse: Field list item has errors

cw88 — Mon, 26 Feb 2024 08:24:05 GMT

Hello,

following a screenshot where you can find the error sign on every table:

I can't tell you steps, it appears at beginning of last week on every existing semantic model without an action from my side.

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Mon, 26 Feb 2024 15:57:16 GMT

Hello cw88 ,

Thanks for using Fabric Comunity.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Tue, 05 Mar 2024 09:12:11 GMT

Hi cw88 ,

We apologize for delay in response. This is happening due to a bug in our system that our team is actively working to fix. We will update you here once it resolves.

Thank you for your patience and understanding.

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Wed, 06 Mar 2024 07:48:40 GMT

Hello cw88 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Re: Semantic model on warehouse: Field list item has errors

cw88 — Wed, 06 Mar 2024 14:25:09 GMT

Hello,

as you wrote yesterday (We will update you here once it resolves) i will wait for your update.

Re: Semantic model on warehouse: Field list item has errors

arpost — Wed, 06 Mar 2024 15:11:36 GMT

Not sure if this is the same issue you're experiencing, cw88, but this may somehow be related to the schema or something. I am also experiencing this issue with a semantic model connected to a Fabric data warehouse. When I try to use the table in a report, I get an error similar to this fake example; the table should be "abr.Store" but is showing "abr.abr.Store".

Really hoping this gets fixed as this will cripple a DW project on which I've been working for months if I can't add my tables.

Re: Semantic model on warehouse: Field list item has errors

cw88 — Thu, 07 Mar 2024 06:35:49 GMT

Hi arpost ,

i think this is another problem, as in my case i have no problems in reports etc., just the error sign/message in the semantic model.

Re: Semantic model on warehouse: Field list item has errors

arpost — Thu, 07 Mar 2024 14:11:03 GMT

Ah. Thanks.

Re: Semantic model on warehouse: Field list item has errors

FritsOrdelman — Thu, 07 Mar 2024 15:05:11 GMT

We are also having this issue. We are having this error on Views that we have made in the Lakehouse. When we add a table the error is not showing. We are in west of europe.

Kind regards,

Frits

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Fri, 08 Mar 2024 05:49:16 GMT

Hi FritsOrdelman ,

We apologize that you're encountering an error. This is happening due to a bug in our system that our team is actively working to fix. We will update you here once it resolves.

Note the tables need to be added to the semantic model first before a table can be created. Just try to check if the tables are added. You need to add that table to the default dataset objects. In the context menu for the table do the following:

Hope this is helpful.

Re: Semantic model on warehouse: Field list item has errors

FritsOrdelman — Fri, 08 Mar 2024 07:43:07 GMT

Hi Anonymous,

To be clear about the situation. We are testing with data from a dataverse connection from Dynamics to a new lakehouse. We have now several tables from de dataverse to our Lakehouse connected. We build sevaral view ontop of the tables. Then we created a new semantec model and put the views and some tables in this new semantec model. When we inport a table we do not see the error also we created a date table in Notebooks via Pandas and also that table does not gives an error only he views. Do we need to put all the tables also in the default semantec model? ifso why?

We now put the tables also in the default model but also we have the same errors.

Also we cannot create a new table in the new model.

kind regards,

Frits

Re: Semantic model on warehouse: Field list item has errors

Anonymous — Fri, 08 Mar 2024 10:18:52 GMT

Hi FritsOrdelman ,

Apologies for the issue you are facing. This is happening due to a bug in our system that our team is actively working to fix. We will update you here once it resolves.

Re: Semantic model on warehouse: Field list item has errors

cw88 — Fri, 12 Apr 2024 15:12:00 GMT

Hi Anonymous ,

do you have an update for me?

Thanks!

Re: Semantic model on warehouse: Field list item has errors

michaelmll — Wed, 17 Apr 2024 12:40:02 GMT

Hi all,

is this resolved or is there a workaround? I'm getting the same error..

First the field list error:

Then I can't load data from the model:

Re: Semantic model on warehouse: Field list item has errors

arpost — Wed, 17 Apr 2024 13:20:52 GMT

michaelmll, I worked with Microsoft Support and was told this had been reported internally. I also communicated with someone from the Power BI team recently and sent a video of the problem and was told this had been shared with the engineers.

That said, this has been a problem for several weeks/months now, and I haven't seen this noted anywhere as a known bug. I've been dead in the water on service-based semantic models because of this issue. I'd recommend raising a support ticket with Microsoft as I think the more people that raise it will help make it a priority.

Regarding workarounds, the only thing I've found is literally rebuilding my model in Power BI Desktop and publishing that way, but then you have to either use DirectQuery or Import.

Re: Semantic model on warehouse: Field list item has errors

michaelmll — Wed, 17 Apr 2024 15:59:32 GMT

arpost Thanks a lot for the reply! I'm going to raise a ticket too.

For Workarounds: I was able to get the default semantic model of the warehouse to work. There it does not show the error. I can connect to that and display data in PBI desktop. But that one would not recognize the relationships I make between my reporting views.

Your workaround does not work for me. I get an SSL error when I try to connect to the warehouse SQL endpoint. Did you by chance find a solution for that?

I opened a separate thread for this, but no helpful replies yet..