Scheduled Refresh Not Working

[Anonymous]

Hello,

Can someone please help me with the Scheduled Refresh.  We have a dashboard that is facing 50+ users, and it is giving me the following error below.  Can some one please help me?

[bajee]

@Anonymous,

issue seems to your dataset.Column id was not found in the table that means some has removed\Deleted  the column from the table.

Please check in table wheather that column is there or not.

Regards,

Bajee.

[GilbertQ]

Hi there,

The error is because it is looking for a column called "ID" on a table called "Approvers"

My guess would be that this column has been removed from the source table or source data.

I would suggest opening the PBIX file, going into the Query Editor and to the "Approvers" table and ensure that the ID column is there. If it is not there you will get the error, which hopefully you should be able to resolve.

[Anonymous]

Thanks guavaq for the reply.  I did as you said, but I do notice that the ID column is still there.  I'm connecting to a Sharepoint Online List.  When I refresh within PBI Desktop, it works.  However, when I try to refresh from the PBI web app online, it gives me the error.  Anything else that I might be missing?

[GilbertQ]

Did you refresh it in Power BI Desktop also?

[Anonymous]

Yes, the refresh works in PBI Desktop but not on the PowerBI Web Service Cloud.

[GilbertQ]

Is this SharePoint online or SharePoint On-Prem?

[Anonymous]

Sharepoint Online 2013

[GilbertQ]

Hi there, I am not sure what the error is besides something changing in the SharePoint list.

[Anonymous · Accepted solution]

I'm thinking maybe PowerBI is case-sensitive so I renamed the 'Id' column to 'ID' column.  We'll see if that fixes the issue.