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

Hi Anonymous ,

 

The Direct Query refresh works on a different way from the imported tables so you will have the need to have schedule refresh for the imported and the direct query is automatic.

 

So summarizing the DirectQuery and Imported are not updated at the same time because they work in different ways for refreshing the data.

 

Check more detailed information in the link below:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you a lot Miguel,

 

So it is sure that the imported merged tables built starting from DirectQuery tables will not be refreshed in the BI Service, but they need a scheduled refresh in order to show the latest data even if the below DirectQueries are refresh and data updated. Is this correct or did I misunderstand?

 

Kind regards,

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Yes that is correct.

     

    But sorry for the question but why are you making merge of tables that come from direct query?