Forum Discussion

VI_Migration's avatar
VI_Migration
Silver Contributor
Nov 18, 2021
Solved

Ways of Working Power BI issue

Hey everyone, I'm running into an issue loading the Ways of Working Assessment PowerBI template, so I thought I'd reach out to this community to see if anyone has come across an easy fix or recommen...
  • Jake_Caddes's avatar
    Nov 19, 2021

    Hi VI_Migration, yes this is a common error message I have seen before. Most likely the issue is coming from your PowerBI credentials.

    Here is a quick step by step guide on how to fix this: 

    • If you were not prompted to sign in with your organizational account while setting up the dashboard and Power BI fails to load the data, follow these steps to clear existing permissions:

      1. In Power BI, open the Transform data menu, and select Data source settings.
      2. Select Global permissions, select https://workplaceanalytics.office.com, and then select Clear permissions.
      3. Select Delete.
      4. Close Power BI and follow the set up instructions for the applicable dashboard.
    • If you are signed in with the wrong organizational account, you'll get an error when loading the data with the template. To fix it, follow these steps:

      1. In Power BI, open the Transform data menu, and select Data source settings.
      2. Select Global permissions, select https://workplaceanalytics.office.com, and then select Edit permissions.
      3. For Credentials, select Edit.
      4. In the OData feed dialog box, select Organizational account, and then select Sign in or Sign in as a different user.
      5. Select the account that you use to sign in to Workplace Analytics, enter the password, and then when prompted in OData feed, select Save.
      6. In Edit Permissions, select OK, and then close the Data source settings window.
      7. Close Power BI and follow the set up instructions in Set up the dashboard for the applicable dashboard.

    Here is documentation on how to trouble shoot this: Power BI tips, troubleshooting, and FAQ | Microsoft Docs

Resources