I am using Version: 2.64.5285.741 64-bit (November, 2018)
After building several dashboard pages in Power BI Desktop, I updated my Excel data source and refreshed the data. Although the refresh process completes without an error, the data is not correct. Some fields/columns that were renamed in Power BI Desktop are not being updated with the new values and since those fields are being used by a calculation, the numbers based on those fields are wrong when I compare the Power BI file to a pivot table in Excel of the same source data.
As a test, I created a copy of the Excel data source, changed the data source in Power BI desktop and refreshed the data again. I still am not getting the correct data in Power BI.
Since there is no reported error, I am unsure whether I can actually trust the data in the dashboard pages. I am not trying to use a scheduled refresh or anything complicated. I just want the data to load correctly. Since I need this for a client project, any help would be greatly appreciated.