Forum Discussion
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?
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.
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.
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.
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?
- Did you refresh it in Power BI Desktop also?
Yes, the refresh works in PBI Desktop but not on the PowerBI Web Service Cloud.