Forum Discussion

jaryszek's avatar
jaryszek
Super User
11 months ago
Solved

Why imported table from onelake is black?

Hello, I added new table from Data LakeHouse into my remote semantic model on top of that (direct lake, no sql endpoint) using XMLA endpoint in tabular editor 3 and my table became black:  ...
  • Ahmed-Elfeel's avatar
    11 months ago

    Hi jaryszek,

     

    The black table color in Tabular Editor indicates that the table is in an unprocessed state this is a common occurrence when you add new tables to a semantic model through the XMLA endpoint

     

    When you add a new table via XMLA:

    • The table structure is created in the model metadata
    • But the table hasn't been processed (data hasn't been loaded)
    • Tabular Editor shows unprocessed tables in black to visually distinguish them

     

    For fixing this you need to process the table to load data from your Data LakeHouse:

    • Right click on the black table

    • Select Process Table

    • Choose processing options (usually "Process Full" for initial load)

    • Execute the processing operation

    Or Use TMSL (Tabular Model Scripting Language):

    {
      "refresh": {
        "type": "full",
        "objects": [
          {
            "database": "YourDatabaseName",
            "table": "YourBlackTableName"
          }
        ]
      }
    }

     

    if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.