Forum Discussion

NamNguyenJH's avatar
NamNguyenJH
Frequent Visitor
6 years ago
Solved

Certain data tables not updating on visualizations

Hey all,   Brand new user to Power BI here. I have played around with the software for almost a month now and have done most of the learning myself, however i have seemed to have found myself in a ...
Need Help
  • NamNguyenJH's avatar
    NamNguyenJH
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

NamNguyenJH's avatar
NamNguyenJH
Frequent Visitor
6 years ago

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