Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Scheduled Refresh Not Working

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?

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

9 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        GilbertQ
        Super User
        8 years ago
        Did you refresh it in Power BI Desktop also?
  • bajee's avatar
    bajee
    Kudo Kingpin
    8 years ago

    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.