Forum Discussion

Tas1's avatar
Tas1
Icon for Advocate I rankAdvocate I
9 years ago

Visual is showing blank where value exist in data view

Hi all,    I'm having a table in visual view showing blank aka: nothing although the the value exists in dataview !! I tried reloading from the data source many times but it's all the same. it's s...
Need Help
ronkochanowski's avatar
ronkochanowski
Frequent Visitor
8 years ago

Hello all,

 

I just crossed this issue today and found that a date field (which was formatted through SQL) was actually displaying in Power BI as Text.  After setting the data type on the Date, the Whole Number values began displaying.  I believe this was due to the Date field being a Join field as well.  Since the join was foiled by different data types, the values associated through that join would not display.

 

Suggest checking your join field data types.

 

Ron

KSturt's avatar
KSturt
Frequent Visitor
8 years ago

I also had this problem today. I had appended 4 tables into one, they appeared in Query Editor but Data View was blank.

 

I went back to my four original tables and filtered out blanks and null values. After refreshing it all worked again. I don't know why this would be, but I'm posting this in the hope that this information helps someone else.