Smaply Helpdesk
  • WELCOME
  • Getting Started
    • Sign up for a free account
    • Join by invitation
    • Switching between accounts
    • First steps in Smaply
    • Smaply: a visual walkthrough
  • Journey map editor
    • Editor features
      • Lanes, columns and cards
      • Filters and views
    • Exporting journey maps
    • Keyboard shortcuts
    • Enhanced pasting functionality
    • Share journey maps
      • Invite users directly to journeys
      • HTML sharing of journey maps
  • Dashboard
    • Dashboard
    • Table actions
      • Filtering in dashboard lists
      • Saved views
      • Bulk actions
      • Copy assets across workspaces
    • Personas
    • Templates
  • Portfolio
    • Opportunities, pain points, solutions
    • Portfolio matrix
  • Integrations
    • Metrics tools
      • Office 365 Excel
        • Configuring the Office 365 Excel integration
          • Setup service account for O365 Excel
          • Setup O365 Excel using Microsoft account (oAuth)
        • Using the O365 Excel integration in a metric
      • Google Analytics
        • Configuring the Google Analytics integration
        • Creating Google Service Account
        • OAuth Authentication for Google Analytics
        • Service account troubleshooting
      • PowerBI
        • Configuring the PowerBi Integration
          • Set up Service Account for PowerBI
            • Troubleshooting powerbi service account setup
          • Set up PowerBi using Microsoft account (OAuth)
        • Using the Power BI integration in a Metric
        • Getting up and running with PowerBI
    • Planning tools
      • Trello
        • Configure Trello with an api key
      • Asana
        • Configuring Asana using a Personal access token
      • Azure DevOps
        • Configuring Azure Devops with a personal token
      • Linear
        • Configuring Linear with Personal API key
      • Jira
        • Configuring JIRA with an api key
    • Embedding external content
  • Metrics
    • Introduction to metrics
    • Types of metrics
      • Series metrics
        • Create a series metric
      • Number metrics
        • Create a number metric
      • Comparison metrics
        • Create a comparison metric
    • Setting up metrics
  • Planning Items
    • Planning item overview
    • Adding a planning item
  • Account settings
    • Upgrade, downgrade or delete your account
    • Access levels and permissions
    • User management
    • Taxonomy
    • Tags
  • Learning resources
    • Video tutorial
    • Blog
    • Books
  • RELEASE NOTES
    • 2025
      • April
      • March
      • February
      • January
    • 2024
      • December
      • November
      • October
      • September
Powered by GitBook
On this page
  • Troubleshooting Power BI Service Account Setup
  • Quick Checklist
  • Automated Verification Tool
  • Manual Verification Steps
  • Common Issues and Solutions
  • Still Having Issues?
  • Additional Resources
  • Need More Help?
Export as PDF
  1. Integrations
  2. Metrics tools
  3. PowerBI
  4. Configuring the PowerBi Integration
  5. Set up Service Account for PowerBI

Troubleshooting powerbi service account setup

PreviousSet up Service Account for PowerBINextSet up PowerBi using Microsoft account (OAuth)

Last updated 1 month ago

Troubleshooting Power BI Service Account Setup

This guide helps you verify and troubleshoot Power BI service account configurations. If you're experiencing issues with Power BI integration, follow these steps.

Quick Checklist

Before diving into detailed troubleshooting, verify these common issues:

Automated Verification Tool

We provide a Python script that automatically checks your Power BI configuration and permissions.

Prerequisites

  • Python 3.6 or higher installed

    • Mac: brew install python3

    • Linux: sudo apt-get install python3

Running the Verification Tool

  1. Download the powerbi_workspace_checker.py script

  2. Open Terminal/Command Prompt

  3. Navigate to the script location:

    cd path/to/script/location
  4. Run the script:

    python3 powerbi_workspace_checker.py
  5. Enter your credentials when prompted:

    • Tenant ID

    • Client ID

    • Client Secret

The script will check:

  • Authentication status

  • Accessible workspaces

  • Permission levels

  • Security group memberships

Manual Verification Steps

If you prefer to check manually, or if the script identified issues, verify these configurations:

1. Azure AD App Registration

  1. Navigate to "App Registrations"

  2. Find your service principal

  3. Verify:

    • Application (client) ID exists

    • Client secret is valid and not expired

    • Required API permissions are granted:

      • Power BI Service

      • Microsoft Graph (if needed)

2. Power BI Admin Settings

  1. Check "Tenant Settings"

  2. Find "Allow service principals to use Power BI APIs"

  3. Verify:

    • Setting is enabled

    • Your security group is listed in allowed groups

    • Changes were made >30 minutes ago

3. Security Group Configuration

  1. Go to Azure AD

  2. Find your security group

  3. Check members list

  4. Verify:

    • Service Principal is a member

    • Group name matches Power BI settings

    • No typos in group name

4. Workspace Configuration

  1. Open Power BI Service

  2. Go to each workspace

  3. Check "Access" settings

  4. Verify:

    • Security group is added

    • Correct permission level assigned

    • Workspace is not personal

    • Changes were made >30 minutes ago

Common Issues and Solutions

Service Principal Can't Access Workspace

  1. Issue: Authentication fails

    • Check: Client secret expiration

    • Solution: Generate new client secret if expired

  2. Issue: No workspaces visible

    • Check: Security group membership

    • Solution: Add service principal to security group

  3. Issue: Permission denied

    • Check: Admin settings

    • Solution: Enable "Allow service principals to use Power BI APIs"

  4. Issue: Changes not reflecting

    • Check: Timing of changes

    • Solution: Wait 2-4 hours, retry

Still Having Issues?

If you've verified all settings and still experience problems:

  1. Run the verification script and save the output

  2. Check Azure AD audit logs for access attempts

  3. Verify network connectivity/firewall settings

  4. Contact Smaply support with:

    • Script output

    • Error messages

    • Timing of issues

    • Steps already attempted

Additional Resources

Need More Help?

Please contact support@smaply.com and we'll try and get you up and running as fast as we can.


Note: Keep your credentials secure and never share client secrets or access tokens. Always follow your organization's security policies when handling service account information.

Go to

Go to

Download Python for Windows
Azure Portal
Power BI Admin Portal
Power BI Service Principal Documentation
Azure AD App Registration Guide
Power BI Admin Settings Documentation
7KB
powerbi_workspace_checker.py