0 Kudos

BUG: Power BI Desktop with local Excel data source does not refresh properly

Status: Needs Info
by sz4C Frequent Visitor on ‎01-21-2019 01:11 PM

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.

Status: Needs Info
Comments
by Moderator v-yuezhe-msft
on ‎01-21-2019 11:31 PM

 

 


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.  

@sz4C,

Could you please share the original excel file through Private Message? I will test it on my side. 

Also we need to know that what columns/data you make changes in the excel and what is your expected result in Power BI Desktop.

Regards,
Lydia

by Moderator v-yuezhe-msft
on ‎01-21-2019 11:32 PM
Status changed to: Needs Info
 
Idea Statuses