Forum Discussion
Why imported table from onelake is black?
- 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.
Hmm but after weekend i see taht table turned to blue:
Why ?
Maybeafter some refresh?
Best,
Jacek
Hi jaryszek ,
The blue color means the table has been processed and data has been loaded successfully. So, it's no longer in the "unprocessed" state. This could have happened after the table underwent a full refresh or process.
You might have initiated a refresh, either through the Tabular Editor or the Lakehouse model itself. Once the refresh completed, the table's status changed to blue, indicating it was successfully processed and data is now available.
Thank you.