Azure Analysis Services: One Table, Multiple Models

Question

Is it possible to use one table in multiple models?

For example, I have more than one model that will use the same Customers table. If I have to make a modification to Customers, I would have to modify EACH Customers table in EACH model. But if I can use the one table multiple times, I will only have to modify the table in one place.

Answer 1

Hi @James H. Robinson ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

As per my understanding and articles I have found, it is not possible to share table among multiple models. For the challenge in modifying same table in multiple models, I think PowerShell script can be used to check a static file/table that has this logic stored and which can trigger processing the table in models that has this table. Please refer to this document for PowerShell commands.

Hope this helps! Please suggest for further queries and we will be glad to assist.

-----------------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.