11-17-2021 05:01 PM
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 recommendation. I'm sure it's a user error on my part, but I can't seem to find what I've missed or messed up.
When loading the Ways of working assessment and Standard meeting queries into PowerBI, I hit the following errors:
"The column 'Subject' specified in the 'SUMMARIZE' function was not found in the input table. The column 'Subject' specified in the 'SUMMARIZE' function was not found in the input table."
"OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (500) Internal Server Error. ( )."
Any thoughts around what might be causing this?
Solved! Go to Solution.
11-18-2021 04:22 PM
Hi @Imran_Thobani, 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:
https://workplaceanalytics.office.com
, and then select Clear permissions.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:
https://workplaceanalytics.office.com
, and then select Edit permissions.Here is documentation on how to trouble shoot this: Power BI tips, troubleshooting, and FAQ | Microsoft Docs
11-18-2021 04:22 PM
Hi @Imran_Thobani, 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:
https://workplaceanalytics.office.com
, and then select Clear permissions.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:
https://workplaceanalytics.office.com
, and then select Edit permissions.Here is documentation on how to trouble shoot this: Power BI tips, troubleshooting, and FAQ | Microsoft Docs
11-26-2021 07:41 AM
Thanks Jake.
Looks like the issue was due to being signed into the wrong organizational account. Appreciate the help!