Forum Discussion
Helper IIIRefresh Failure when Pulling from SFDC Objects
Not much you can do to prevent it from happening again, especially if your process depends on one of the changed fields.
Familiarize yourself with:
- the difference between Table.SelectColumns and Table.RemoveColumns
- query folding for SFDC object queries
- the concept of [Column ]?
- the Value.Is Power Query function.
Community SupportHi astano05 ,
Even the column is not used in teh visuals, if its part of your earlier query then Power BI will look for that column and hence it will throw the error if its not available in the data source.
Please try the below steps:
1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)
2 - Refresh the data in the query editor and apply.
3 - Publish the report from PBI Desktop to service and replace the report.
4 - Set the schedule refresh.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
astano05thanks for the reply. Will this fix the issue moving forward if columns are changed or is this simply to fix the issue? I'm asking because I know how to resolve it when it happens, but I want it to prevent it from happening from future SFDC changes.
- lbendlin
Super User
Not much you can do to prevent it from happening again, especially if your process depends on one of the changed fields.
Familiarize yourself with:
- the difference between Table.SelectColumns and Table.RemoveColumns
- query folding for SFDC object queries
- the concept of [Column ]?
- the Value.Is Power Query function.