Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Mixed Storage in Composite Models (DirectQuery + Import) for Desktop and Service

Good afternoon to the community,   I have a techincal question about the software:   We are implementing some reports using multiple Direct Queries as sources and we are merging them in the power...
General Comment
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am not sure that merged imported tables originated from DirectQueries are not refreshed as well, it sounds weird to me, but we will se that soon 🙂

 

The problem is that the original reports are composed by 4+ (up to 11) different SQL queries so that it becomes a bit complicated to apply full joins directly in the statements. Moreover, often they are joined on multiple fields (even 10) and it is difficult to link the models graphically. We are trying to simplify the process and speed up the project using BI capabilitie. That's why, do you have an other idea about this?

 

Kind regards,

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Let me try an call out a superuser that has some expertise on some implementations and maybe he can tell us if both tables are updated.

     

    parry2k  Can you please tell us if the composite models the tables in import mode are update always that the direct tables are also updated? I believe that they are not dispite they might be based on the DirectQuery tables.

     

    I did not made any composite models implementation in this manner.