Forum Discussion
Mixed Storage in Composite Models (DirectQuery + Import) for Desktop and Service
Hi Anonymous ,
The information will be updated at the same time however the import tables depending on the connection you are using (files, ODBC, SQL, ...) needs to be setup the connection also on the portal otherwise if you are making changes to the import and there is no conneciton setup those tables will always be the same and not updated.
Check the blog post below with the setup of the datasources refresh.
https://www.cittabase.com/power-bi-tips-schedule-refresh-on-composite-models/
Good Morning MFelix,
thank you for the answer, I have read the article: however we cannot schedule the refresh because the reports should act as they are DirectQuery only, even if merged tables are imported, so that all data are refreshed when the user launches the report in BI service (without a schedule, but on demand).
We are using a connection string for Oracle DB and the DB address for SQL Server embedded in the DirectQuery in the .pbix file in BI Desktop. Are all the tables (DirectQuery and merged imported) refreshed at the same time without any schedule?
We are not able to try this by ourselves as the client is installing the Gateway to enable BI Service.
Kind regards,
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
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,
Yes that is correct.
But sorry for the question but why are you making merge of tables that come from direct query?