The column 'Column1' of the table was not found

[prak2419]

Describe the bug Loading the CCO dashboard fails with error 'The column 'Column1' of the table was not found'

To Reproduce Steps to reproduce the behavior:

1. Open the CCOInfradashboard v9.1.pbit file
2. Enter the org. credentials

Expected behavior Powerbi dashboard for Azure Infra

Screenshots

Desktop (please complete the following information):

• OS: Windows 11
• PowerBI Version: 2.103.661.0

Additional context The user is signing in with the organizational account with proper credentials. We tried clearing all the credentials and reload still no luck.

[trdvangraft]

I am facing similar issues! Lets keep each other posted on progress

[kukisama]

I encountered the same problem and tried several versions, but they are still unavailable. I tried to use three accounts, none of which is available:

@live. Cn users onmicrosoft. Users under com New account under custom domain name

Global administrator permissions are configured and are still unavailable.

[josunefon]

You need to have RBAC permissions at subscription or MG level, AD tenant permissions are required to retrieve data from users/spns (GRAPH API)

[prak2419]

The user has owner permissions at the subscription level and he is a global administrator for their Azure AD. Still, the page doesn't load and ends up with the same error.

[josunefon]

@prak2419 can you try with the latest 9.1 version updated 14 days ago?

[mosorio29]

Hi everyone,

Did you find the solution for this? I am facing the same problem. I already installed the latest version, but I am getting the same issue.

[josunefon]

Hi @mosorio29 did you check https://github.com/Azure/CCOInsights/issues/105#issuecomment-666220426 ?

[josunefon]

closing the issue after no response provided