Forum Discussion

cw88's avatar
cw88
Icon for Helper IV rankHelper IV
2 years ago
Solved

Semantic model on warehouse: Field list item has errors

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 see...
data warehouse
power bi
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi cw88 ,

    Apologies for the delay in reply from our side. We have an update from team that above mentioned bug got fixed. 

    There was a bug that was misrepresenting direct lake tables and showing them all with this warning triangle. Now fixed.


    Can you please check and confirm?

    Hope this is helpful.



michaelmll's avatar
michaelmll
Frequent Visitor
2 years ago

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: 

 





  • arpost's avatar
    arpost
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    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.

    • michaelmll's avatar
      michaelmll
      Frequent Visitor
      2 years ago

      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.. 

      • arpost's avatar
        arpost
        Icon for Post Prodigy rankPost Prodigy
        2 years ago

        michaelmll, are you trying to connect via Power BI Desktop? If so, I had to use the SQL Server connector and provide the data warehouse's SQL connection string.