cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Powerbi_astra
Helper V
Helper V

data showing only when i sum numeric values

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

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Powerbi_astra , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@Powerbi_astra 

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
Super User IV
Super User IV

@Powerbi_astra , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors