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.
jaryszek Did you add any calculated column on the black table ? If you have added it then your table would fall back to direct query.
Thanks,
Jai
You can not add column in onelake mode. It will only work with SQL endpoint flavour I suppose.