Forum Discussion

astano05's avatar
astano05
Icon for Helper III rankHelper III
4 years ago
Solved

Refresh Failure when Pulling from SFDC Objects

I have several reports pulling Salesforce.com objects, but every time a field is deleted from an object, I get a failure on my scheduled refresh. Manually refreshing the reports will fix the issue, b...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

astano05's avatar
astano05
Icon for Helper III rankHelper III
4 years ago

thanks 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's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.