You are administering a Power BI workspace for a user with a Power BI Pro license. The workspace contains an Import-mode semantic model that retrieves data from an on-premises SQL Server database. You have a new requirement for the model to refresh every 30 minutes during business hours. What must you do first to enable this refresh frequency?
Assign the workspace to a Premium capacity.
Define an incremental refresh policy on at least one table.
Switch the gateway connection to DirectQuery mode.
Enable the large-model format for the semantic model.
To schedule a refresh interval more frequently than the default eight times per day allowed with a Power BI Pro license, the semantic model must reside in a workspace assigned to a Power BI Premium or Premium Per User (PPU) capacity. Premium capacity increases the maximum number of scheduled refreshes to 48 per day, which supports a 30-minute refresh schedule. Without Premium capacity, the service limits refreshes to eight per day, making the required schedule impossible. Neither the gateway mode, storage format, nor an incremental refresh policy increases the scheduled refresh frequency limit.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Power BI Premium capacity?
Open an interactive chat with Bash
What is the difference between Import mode and DirectQuery mode?
Open an interactive chat with Bash
What is an incremental refresh policy in Power BI?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Manage and secure Power BI
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .