Azure Analysis Services: One Table, Multiple Models

James H. Robinson 161 Reputation points
2020-10-27T21:57:39.417+00:00

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.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
0 comments
Accepted answer
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-10-28T12:28:39.62+00:00

    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.
    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest