Forum Discussion

HeenaPat's avatar
HeenaPat
Regular Visitor
6 years ago

Refresh error

This is the error we keep receiving on autorefresh of this report. The Age(days) column does exist. Data is pulled in from a Salesforce report. Any suggestions? Thank you An error occurred while pro...
Need Help
metrica's avatar
metrica
Icon for Post Prodigy rankPost Prodigy
2 months ago

Hi HeenaPat 

 

Since manual refresh works but scheduled refresh fails, I would not treat this as a simple missing-column issue.

The error means that during Service refresh, Power BI receives a rowset that does not contain Age (Days), even if the column appears in the Salesforce report UI. I would check:

  1. Whether the column label changed slightly, including spaces or capitalization.

  2. Whether Age (Days) is a formula or calculated field that may behave differently through the Reports connector.

  3. Whether Power BI Service uses the same Salesforce user and permissions as Desktop.

  4. Power Query steps such as Changed Type, Renamed Columns, Removed Columns, or Reordered Columns that reference Age (Days).

  5. Salesforce credentials, gateway settings, and refresh history in Power BI Service.

The native Salesforce Reports connector can be sensitive to report schema and also has the frustrating 2,000-row limit.

 

Another option is to prepare the Salesforce dataset before it reaches Power BI.

 

Power BI Connector for Salesforce by Metrica Software can help: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

It lets you select Salesforce objects and fields, apply filters, preview the output, and use SOQL mode when needed. This can help create a more controlled Salesforce-to-Power BI source instead of depending on a report schema that may behave differently during scheduled refresh.

 

Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/

 

Cheers,
Metrica Team