Forum Discussion

diegoervitiq's avatar
diegoervitiq
Regular Visitor
11 months ago

Creating a Semantic Model via TOM with ODBC Connections

I’m trying to create a Tabular Semantic Model programmatically using TOM (Tabular Object Model) and I’m running into issues when using ODBC connections. I’m creating the database and adding data sou...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-sdhruv's avatar
v-sdhruv
Icon for Community Support rankCommunity Support
11 months ago

Hi diegoervitiq ,
Thank you for providing detailed explaination for your query.
Mybe you can try to split the operations into two transactions.

do not add data source and refresh the model in the same transaction.
Add the data source and save the model.In a seperate operation, request for refersh.

model.RequestRefresh(RefreshType.Full);
model.SaveChanges();

 

This separation ensures that the credentials are properly registered before a refresh is attempted.
ODBC sources often fail when using workspace identity authentication. Instead, use explicit credentials or service principal authentication.
Consider using Power Query (M Expressions) for Import Mode.
Load data from sources like Snowflake or PostgreSQL. This method is more reliable in Premium workspaces.

Hope this helps!