Emissions Impact Dashboard Data Refresh Issue

Hi  jeanloz 

1. Is the dashboard a combination of multiple reports?
2. What are the corresponding data sources?
3. Can the reports related to this dashboard be refreshed normally?
4. Are all the data sources associated with this dashboard working properly?

Best Regards,
Community Support Team _ Ailsa Tao

Hi Anonymous we have the same error with 2 diffent Emissions Impact Dashboard for Azure.
I have also try to update the App, but get the same error.

1. Is the dashboard a combination of multiple reports?

> no
2. What are the corresponding data sources?
> WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
3. Can the reports related to this dashboard be refreshed normally?
> no, same error
4. Are all the data sources associated with this dashboard working properly?

> we use just the default App (https://appsource.microsoft.com/de-DE/product/power-bi/coi-sustainability.emissions_impact_dashboard) without any changes

kind regards

Frank

Anonymous  

1. Is the dashboard a combination of multiple reports? No

2. What are the corresponding data sources? WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net

3. Can the reports related to this dashboard be refreshed normally? No.   Doing a manual refresh returns the same error 

Data source errorExpression.Error: The column '<ccon>DateKey' of the table wasn't found.. DateKey. </ccon>. The exception was raised by the IDbCommand interface. Table: DimDate.

4. Are all the data sources associated with this dashboard working properly? This is the default Microsoft Emissions Impact Dashboard app that is described here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-to-emissions-impact-dashboard

We see the exact same error.

1. Is the dashboard a combination of multiple reports? No

2. What are the corresponding data sources? WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net

3. Can the reports related to this dashboard be refreshed normally? No. Doing a manual refresh returns the same error 

Data source error:
Expression.Error: The column '<ccon>DateKey' of the table wasn't found.. DateKey. </ccon>. The exception was raised by the IDbCommand interface. Table: DimDate.

4. Are all the data sources associated with this dashboard working properly? This is the default Microsoft Emissions Impact Dashboard app that is described here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-to-emissions-impact-dashboard

Same issue, started last week. Updated the app, but nothing has changed.

Updated on the 13th July - getting same error - clearly there is something wrong with the update. Also tried to install a new instance of app and got the same error. Next time I will install a new instance of app as a test ! 🙂

Data source error: Expression.Error: The column '<ccon>DateKey' of the table wasn't found.. DateKey. </ccon>. The exception was raised by the IDbCommand interface. Table: DimDate.
Cluster URI: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID: 78c4beda-2132-3909-24e1-3e783d16c95f
Request ID: 6ca5eeb7-3aa5-eb37-3c8c-7620cb09e2dd
Time: 2023-07-18 19:34:38Z

Hi, dear community members,

I am facing the same issues in one of my report.

When I refresh the datas at Power BI Desktop, it woks fine.

But getting similar error at power bi service - for both on demand refresh and schedule refresh.

It says, they are not getting a column in the table, but IT EXISTS THERE 🙂

Problem seems to have been solved.

The Emissions Impact Dashboard now refreshes without any issues.

I confirm, it's now working. It was not working for me since July, 11.

Great news!

HI jeanloz 

I've seen feedback from some users that the issue has been resolved, is it working properly on your end?

Best Regards,
Community Support Team _ Ailsa Tao