Question about Direct Query + import

[henrychoiyw]

Hi,

I am trying to create a report that coming from two sources (Dataverse & Azure SQL database). I use Direct Query for Dataverse and Import for Azure SQL database. The data on Dataverse is live data and the data in Azure SQL database is a freeze or view only. I used append to combine both tables and it could load all the records as I expected. However, the auto refresh seems does not work. The dataset stopped on 17th Jun. 

I want to ask am I doing the right way or there is other way to do so that I can keep loading the latest data with Direct Query and can still combine the table from Azure SQL Database.

Thank you very much in advance.

Henry

[rajendraongole1 · Accepted solution]

Hi @henrychoiyw -When you use DirectQuery and Import in the same dataset, ensure that the append operation correctly handles the mixed storage mode. The append query should trigger a refresh of the DirectQuery part when queried.

Combining live and static data sources in Power BI can be done effectively using DirectQuery for real-time data and Import for static data.

Verify that your Power BI Service settings allow for automatic refresh. Go to the dataset settings in Power BI Service and ensure scheduled refresh is enabled and configured correctly.

with proper configuration of refresh settings and credentials is key to maintaining up-to-date data in your reports.

If the automatic refresh does not work as expected, reviewing the dataset settings and monitoring refresh logs in Power BI Service is crucial for troubleshooting and resolving issues.

similar question answer FYR:

Solved: import vs direct query decision - Microsoft Fabric Community