data showing only when i sum numeric values

[Anonymous]

I am connecting to redshift using power bi

1. last week I created a table named mytable...and was able to connect, today i just dropped it and recreated it with modified structure, when I connect from power bi desktop, its showing the old structure, why is this happening

2. I then created mytable1, now I am able to connect to mytable1, problem is when I load data into a table visualization, it shows data only when my numeric column is summarized, i dont want it to be summarized so when i choose "dont summarize", the data in the table becomes empty the minute i choose not to summarize the numeric column, any idea why this is happening

[V-pazhen-msft]

@Anonymous 

I cannot reproduce this. Are you able to reproduce this issue maybe create a short sample and share the sample pbix.

Paul Zheng _ Community Support Team

[amitchandak · Accepted solution]

@Anonymous , go to power and refresh the table. if it does not pick up then try like suggested in the video

Refer : https://www.youtube.com/watch?v=h0yLtceT0i4