Power BI Report Setup for Work 365

Audience: Administrators, BI Analysts

Overview

This guide provides detailed instructions for configuring, publishing, and maintaining Power BI reports for Work 365.
It covers all key phases — prerequisites, workspace setup, Power BI Desktop configuration, report publishing, dataset credential setup, and scheduled refresh management.

Prerequisites

Before you begin, ensure the following requirements are met:

1. Pre-Publish Steps

A. Create a Workspace

1. Sign in to Power BI Service with your Microsoft 365 account.

2. Go to Workspaces → Create a workspace (e.g., Work365 Reporting).

3. Use a dedicated or shared workspace accessible to your analytics or finance team.

B. Grant Access to the Work 365 Integration Account

1. In your new workspace, go to Settings → Access.

2. Add your Work 365 integration/service account as a Contributor.

3. This account will be used for dataset refresh and data source access.

2. Configure the Report in Power BI Desktop

1. Open the Work 365 sample .pbix file (or your organization’s customized version).

2. Go to Transform Data → Edit Parameters.

3. Update the following fields:

   • Work 365 Environment URL

   • Any organization-specific filters (e.g., region, customer type)

4. Click OK → Apply Changes.

When prompted for authentication:

• Select Organizational account.

• Sign in using your Microsoft 365 credentials (you may be prompted twice).

✅ Validate the data:

• Test filters such as Year, Customer, or Billing Contract.

• Confirm visuals load successfully without query errors.

3. Publish the Report

1. In Power BI Desktop, click Publish.

2. Sign in if prompted.

3. Select your Work365 workspace.

4. Wait for the confirmation message: Publish successful.

⚠️ If the workspace doesn’t appear:
Ensure your account has Member or Contributor permissions in that workspace.

4. Post-Publish Configuration

A. Configure Dataset Credentials

1. In Power BI Service, open your Work365 workspace.

2. Go to Datasets → (⋯) → Settings.

3. Under Data source credentials, click Edit and set:

4. Sign in using the same Microsoft 365 or integration account that has access to Work 365.

B. Set Up Scheduled Refresh

1. In Dataset Settings, open Scheduled refresh.

2. Enable Keep your data up to date.

3. Configure:

   • Frequency: Daily (or hourly if using Premium)

   • Time zone: Match your organization’s reporting cycle

   • Notifications: Enable email alerts for refresh failures

4. Click Apply to save.

Notes

Additional Considerations:

• Ensure the dataset credential account is licensed, active, and exempt from password expiration.

• Multi-factor authentication (MFA) changes can interrupt scheduled refreshes — reauthenticate if needed.

Troubleshooting & Tips

Security & Row-Level Security (RLS)

If your organization uses Row-Level Security:

1. In Power BI Desktop, go to Modeling → Manage Roles.

2. Define roles and rules for data access.

3. Publish the report to Power BI Service.

4. In Dataset → Security, assign users or Azure AD groups to the defined roles.

This ensures each user only sees data relevant to their role or region.

Maintenance Best Practices

? Credential Hygiene

Use a dedicated integration account licensed for Power BI Pro or covered under Premium capacity.

? Documentation

Maintain a small runbook with:

• Work 365 Dataverse OData URL

• Dataset parameters

• Credential owner and refresh schedule

? Monitoring

Enable email notifications for refresh failures and review refresh history weekly.

? Version Control

Store .pbix files in SharePoint, OneDrive, or Git with clear version tags for rollback capability.