Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

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:

  • Requirement: ? Power BI Pro License Description: Required for users who publish or share reports.
  • Requirement: ? Power BI Desktop Description: Installed on your local machine.
  • Requirement: ? Access to Power BI Service Description: Including permission to create or edit workspaces.
  • Requirement: ? Work 365 Dataverse OData URL Description: Example: https://yourenvironment.crm.dynamics.com/api/data/v9.2
  • Requirement: ? Integration Account (Recommended) Description: A dedicated Work 365 service or integration account for scheduled refresh authentication.

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:

  • Setting: Authentication method Value: OAuth2
  • Setting: Privacy level Value: Organizational

  1. 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

  • Plan Type: Power BI Pro Workspace Refresh Limit: Up to 8 refreshes per day
  • Plan Type: Premium Capacity Workspace Refresh Limit: Up to 48 refreshes per day

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

  • Issue: Cannot see workspace when publishing Possible Cause: Insufficient permissions Resolution: Verify Member/Contributor access in the workspace.
  • Issue: Repeated credential prompts / Apply Changes fails Possible Cause: Wrong authentication type Resolution: Re-authenticate using Organizational account for all sources. Restart Power BI Desktop.
  • Issue: Scheduled refresh failing Possible Cause: Invalid or expired credentials Resolution: Reconfigure credentials under Data source settings → OAuth2 and verify Work 365 access.
  • Issue: Report changes not appearing in Service Possible Cause: Cached version of report Resolution: Re-publish the updated .pbix to overwrite the existing one.

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.