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
parry2k's avatar
parry2k
Super User
5 years ago

MFelix Thanks for reaching out. 

 

Anonymous Can you please put more details? When you say direct query and merge it with import table what does this mean? 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Felix and Parry,

 

So I am uploading Q_Rimborsi1 and Q_Rimborsi2 in DirectQuery from an Oracle DB. I cannot make a join in the SQL statement, so I have used the option "Combine/Merge Query" in Power Query Editor that creates an imported table -> Q_Step1, as represented in the screenshot below.

 

This is now a composite model/mixed storage. When I refresh the report in BI Service, will the merged imported table Q_Step1 simultaneously update together with the DirectQueries as they are the source of the imported table?

 

I hope this was clear enough, thank you for your help!!

 

Kind regards,