FX Conversion Logic

Hi SBertozzo77 

Hi,
This type of mismatch is pretty common, even if the difference is small. A few things to check:

1. Data source mismatch
   The Salesforce report might not be using the DatedConversionRate object directly. It could be using a custom rate table or a snapshot entered manually.

2. Time zone or refresh timing
   Even a few hours difference between the Salesforce report and your Power BI refresh can cause discrepancies, especially on days with high FX volatility.

3. Calculated logic in the Salesforce report
   Sometimes rates are applied indirectly using formulas, triggers, or Apex logic. Make sure you're not comparing raw data to derived values.

4. Rounding or formatting
   Power BI might be rounding or trimming decimals. Check the exact precision being used on both sides.

What you can do:

• Export the Salesforce report as CSV and compare it directly in Power BI, including the currency pair and rate date.

• Make sure you're pulling the exact version of the rate table used in the report — not just assuming it's DatedConversionRate.

• If needed, build a validation table in Power BI that compares expected vs. actual values, and send that to Finance.

  If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.