Forum Discussion
Certain data tables not updating on visualizations
Anonymous
Hi Xiaoxin,
Thank you very much for your advice. I checked out the query table and found the problem!
The data was being stored as a whole number rather than a decimal number.
The reason why this was probably happening was due to when i originally obtained and transformed the data, my excel table had the numbers in a table like this
0 0.55 1 0.97 0.66 1 1 0 0.2 0.45
When it started transforming the data, it probably registered the numbers as
W D W D D W W W D D
Where W = Whole Number and D = Decimal Number
So for live comparison
VS
After i made the change the numbers have been spot on.
Lesson learned: Always pay attention to how the data is formatted and what it is being transformed into
Thanks for your help again.
Regards,
Nam
Hi NamNguyenJH,
It seems like you are using excel formulas to processing these calculations and try to get data to power bi but these calculations fields keeps blank on power bi side, right?
For your scenario, DAX formulas are calculated base on its contents. (these calculations are dynamic change based on current row contents) Power bi recognizes them as table fields and loading these fields without processing with their expressions, so you get the blank field values and formatted as the default result 0.
I'd like to suggest you use the import feature to loading excel contents, it also lading these calculate formulas to power bi.
Import Excel workbooks into Power BI Desktop
Regards,
Xiaoxin Sheng
Anonymous
Hi Xiaoxin,
Thank you for your reply. Yes i am using excel formulas, however i am doing it for all 26 of my tables. Please see below for a screen snippet of my excel sheet with formulas shown.
They simply all just refer to another part of the excel document for their values. However it is just the table at the top that seems to have a mismatch with information and doesnt update properly, which is reflecting in my power BI report.
I refreshed the report and took a snapshot of both the excel table vs the data in power BI, as you can see they are vastly different and i dont think it is an issue with displaying blank fields. It feels like Power BI is reading old data and refusing to update with newer information.
What makes it worse is that it seems to be unique to just the one table. I have deleted the table and connections, re-created the table under a different name and still result in the same problem.
Thank you again in advance for your help.
Regards,
Nam
HI NamNguyenJH,
Have you checked the backend query table connection to confirm if they mapping to database or link to excel file? If they are linked to an excel file, power bi refresh operations not triggered the excel file data refresh.
You need manually update and save changes on excel side then you can use the refresh button to bring the latest data to power bi desktop.
Regards,
Xiaoxin Sheng
Anonymous
Hi Xiaoxin,
Thank you very much for your advice. I checked out the query table and found the problem!
The data was being stored as a whole number rather than a decimal number.
The reason why this was probably happening was due to when i originally obtained and transformed the data, my excel table had the numbers in a table like this
0 0.55 1 0.97 0.66 1 1 0 0.2 0.45
When it started transforming the data, it probably registered the numbers as
W D W D D W W W D D
Where W = Whole Number and D = Decimal Number
So for live comparison
VS
After i made the change the numbers have been spot on.
Lesson learned: Always pay attention to how the data is formatted and what it is being transformed into
Thanks for your help again.
Regards,
Nam