Refresh Failure when Pulling from SFDC Objects

[astano05]

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, but is there a way to avoid this?

"Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

The '<pii>Market_Type__c</pii>' column does not exist in the rowset. Table: Opportunity.

Next refresh for REPORT is scheduled for March 4, 2022 11:00 UTC"

[V-lianl-msft]

Hi @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.

[astano05]

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 · Accepted solution]

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.

[lbendlin]

There is no way to avoid that. Tell your SDFC administrators to stop messing with the objects.