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

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.

  • michaelmll's avatar
    michaelmll
    Frequent Visitor
    2 years ago

    arpost I see. Unfortunately, it's the same error. 
    Which version of PBI Desktop are you using? I was reading about an error in the Feb Version but I've tried December and October too without luck.

     

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

      Here's my version: 2.128.952.0 64-bit (April 2024)

       

      I used the Azure SQL DB connector just now and didn't get an SSL error; are you using the Microsoft Store version of Power BI Desktop or direct download from Microsoft? I'm running the Store app.

      • michaelmll's avatar
        michaelmll
        Frequent Visitor
        2 years ago

        Thanks again! I just removed everything. Reinstalled the same version as you from the store. Tried on a different machine. Created a new Fabric Trial. Created a new Workspace with a new Warehouse. Same Error. ğŸ˜‘

        I can use e.g. Azure Data Studio to connect from the same machine to the same warehouse without any problem. I don't get it. 

        Maybe you're in a different region? I'm in Europe-West.