Forum Discussion

FrisoW's avatar
FrisoW
Helper I
6 years ago
Solved

Empty columns

Dear,   Since a couple of days I have an issue with data in a dashboard. When importing a table, all columns are filled in in the query view. When I apply & close, the data view has 3 empty columns...
Need Help
  • rajulshah's avatar
    rajulshah
    6 years ago

    FrisoW, Can I see the screenshot of the transformation steps?
    OR 
    You can do 1 thing : You can filter the blank values and then 'Close & Apply' the changes and see what you can see?

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

FrisoW, Can I see the screenshot of the transformation steps?
OR 
You can do 1 thing : You can filter the blank values and then 'Close & Apply' the changes and see what you can see?

FrisoW's avatar
FrisoW
Helper I
6 years ago

Transformation steps:

 

Source

Navigation

Removed Other Columns (all but those 5)

 

Filtered blanks in statuscode_display column, all 30000 values appeared.

Other columns remained empty, so filtered those as well. All values appeared.

 

This makes completely no sense but you managed to solve it anyway, thanks a lot!

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi FrisoW ,

    It seems that you have resolved the issue. Please accept the helpful answer as a solution. More people who have the same problem will benefit from the thread.