Forum Discussion

Vysh27's avatar
Vysh27
New Member
1 year ago

Redshift data and Power BI data are not matching up

Hi Everyone , I have been facing an issue with the data in power BI which comes from AWS redshift I'm validating the count of distinct guardians for a particular date with AWS redshift data. I have...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Vysh27 ,

It seems like there is data mismatch between AWS redshift and Power BI side when apply a date filter.  Could you please provide the following info?

  • Please provide the "filter" setting(slicer or filter pane).
  • What's the date format of date field? What's the timezone?
  • Is there any NULL values for this date field?
  • Could you please provide some records(especially date field should be specific to the hour, minute, and second ) which display in Power BI but not display in AWS Redshift in the same date period?

Best Regards