Level 2: Setting Up Your Power BI Environment for Copilot
Welcome back! In Level 1, you learned what Copilot in Power BI is and how it can help you create reports faster. Now it's time to roll up your sleeves and prepare your environment so you can actually start using it. Think of this like setting up a new game console: you need to plug in the cables, connect to the internet, and install the latest updates before you can play. In this level, we'll do exactly that for Copilot.
Step 1: Enable Copilot in Power BI Service Settings
The first step happens in the cloud—the Power BI service (app.powerbi.com). Copilot is not automatically turned on for every tenant. You (or your Power BI admin) need to enable it in the tenant settings.
- Sign in to the Power BI service as an admin (or ask your admin to do this).
- Click the gear icon (Settings) in the top-right corner, then select Admin portal.
- In the left menu, choose Tenant settings.
- Scroll down to the Copilot section. You'll see a setting called "Allow Copilot for Power BI" or similar.
- Toggle it to Enabled. You can also choose to apply it to specific security groups if you want to test it with a small team first.
- Click Apply to save.
Important: This setting controls the entire organization. If you don't see the Copilot section, your organization may not have the required license (Copilot for Microsoft 365). Check with your admin.
Step 2: Verify Tenant-Level Permissions for Copilot
Enabling the setting is not enough—you also need to ensure that users have the right permissions. Copilot uses Microsoft's AI services, which require a couple of things:
- Users must have a Copilot for Microsoft 365 license (or a license that includes Copilot). This is separate from a regular Power BI license.
- Users must be in a supported region (most regions are supported, but some government clouds may not be).
- The tenant must allow data movement across regions if your data is stored in a different region than the AI service.
To verify permissions:
- In the Admin portal, go to Tenant settings > Copilot.
- Look for the setting "Use Copilot for Power BI" and make sure it's enabled for the users or groups you want.
- Check the Azure AD roles—users need at least the Power BI Admin role or be a member of a security group that's allowed.
Analogy: Think of this like a concert. The venue (Power BI service) has opened its doors (setting enabled), but you still need a ticket (license) and to be on the guest list (permissions). Without both, you can't get in.
Step 3: Install Required Updates for Power BI Desktop
Copilot features in Power BI Desktop (the app you use to create reports) require a recent version. If you're using an old version, you might not see the Copilot button.
- Open Power BI Desktop.
- Click File > Account > Check for updates.
- If an update is available, download and install it. Restart Power BI Desktop.
- After updating, go to File > Options and settings > Options > Preview features.
- Make sure "Copilot for Power BI" is checked (it may be enabled by default in newer versions).
- Click OK and restart Power BI Desktop again.
Note: Copilot in Power BI Desktop is currently in preview, so you need to explicitly enable it. Once enabled, you'll see a Copilot icon in the ribbon (usually under the Home tab).
Putting It All Together
Once you've completed these three steps, you're ready to use Copilot in both the Power BI service and Power BI Desktop. Here's a quick checklist:
- Copilot enabled in tenant settings (Admin portal)
- Users have appropriate licenses and permissions
- Power BI Desktop updated and preview feature enabled
If you run into issues, the most common problems are:
- Missing license – Check with your Microsoft 365 admin.
- Outdated Desktop – Always update to the latest version.
- Setting not applied – Wait a few minutes for changes to propagate.
Key Takeaways
- Copilot must be enabled in the Power BI service tenant settings by an admin.
- Users need a Copilot for Microsoft 365 license and proper permissions.
- Power BI Desktop must be updated and have the preview feature enabled.
- Always verify that settings have taken effect before troubleshooting.