🔥 3-day streak
Microsoft Power BI Data Analyst52 / 205
Question 52 of 205

You manage a semantic model that imports 5 years of sales transactions, totaling over 200 million rows, from an Azure SQL Database. Full daily refreshes now exceed the refresh time window and frequently fail. Only the most recent 10 days of data ever changes at the source; older data is static. You must reduce refresh duration and reliability issues while keeping historical data available. What should you configure?

Reviewed for accuracy · Report an issueNext question