Forum Discussion

alsalikh_1416's avatar
alsalikh_1416
New Member
1 year ago
Solved

Number Mismatch Between Power BI Desktop and Service

Hello,   I have a report in Power BI where I receive numbers from a SharePoint list. The model is very simple, consisting of just numbers and dates. I adjusted the date to the local timezone by add...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi alsalikh_1416 , It might be because of rounding differences or data refresh inconsitencies

    • Rounding: Ensure correct data type and explicitly round values using Power Query or 

      RoundedValue = ROUND(SUM(Table[Column]), 2)

    • Time Zone: Verify the 3-hour adjustment doesn't exclude rows due to mismatched time zones.

    • Data Refresh: Ensure the dataset in Service is refreshed and matches Desktop.

    • Filters: Confirm identical filters and aggregation logic in Desktop and Service.

    • Regional Settings: Match regional settings between Desktop and Service.
      If this post helped please do give a kudos and accept this as a solution
      Thanks In Advance

     

alsalikh_1416's avatar
alsalikh_1416
New Member
1 year ago

Hello, thank you for your answer.

The problem was in rounding, power BI rounded to the smaller value, while the Sharepoint rounded to the bigger value.

I used this formula in the Power Query: Number.RoundUp([Column])