Forum Discussion
Connect to Tabular Object Model using Powershell => empty model object
Hi v-veshwara-msft ,
Thanks for your answer. I think I have to conclude that TOM can't be used when dealing with a composite model. I always wonder myself how a tool like Tabular Editor does this then. It's a bit of a shame, because TOM is so helpful to quickly do some changes using Powershell.
Hi Peter_MTG ,
Thanks for the follow-up.
In scenarios involving composite models, especially those with DirectQuery connections to Power BI datasets or Analysis Services models, there might be cases where TOM doesn't return all model metadata in PowerShell. While it can work with live connections and show tables and relationships in many cases, certain external or linked sources might still lead to limitations or unexpected behavior.
Tabular Editor can connect to the same XMLA endpoint but also integrates with the running Power BI Desktop session, which may allow it to access additional metadata, including from cached or session-specific content.
Agreed that TOM is very efficient for making multiple updates at once, and it would be helpful if it supported a wider range of model types.
You could consider submitting this as an idea in the Ideas Forum for broader visibility and also to find inputs from others who might have worked around similar limitations.