Connect to Tabular Object Model using Powershell => empty model object

Hi Peter_MTG ,

Thanks for posting in Microsoft Fabric Community and sharing the script and explanation.

This might be related to how TOM interacts with composite models that include remote sources using DirectQuery, such as Power BI datasets, Analysis Services models.

In such cases, the $db.object may appear empty, as TOM typically surfaces only the metadata that's locally defined in the model. Tables and relationships from remote sources might not be accessible through this method.

You had shared a similar scenario earlier where changing from the Power BI Dataflows (Legacy) connector resolved the issue, which could suggest that certain connectors or model configurations affect how TOM sees the model.

Please go through these links for more details:
Programming Power BI semantic models with the Tabular Object Model (TOM) | Microsoft Learn

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Hope this helps. Please reach out for further assistance.

Thank you.