Forum Discussion
Power Query Filter results in Empty Table when it shouldn't
I am trying to import a large dataset from Redshift into Power BI. To make the data more manageable for PowerBI, I am trying to filter it so it only has the rows that I need in it. However, one of th...
PhilipTreacy
Super User
Super UserWell, if you are sure the data you are filtering for is in the data set, remove the last 2 steps that are doing the filtering, load the entire dataset and check for the values you expect to be there.
Phil
I can't load the entire dataset, it is too large. The redshift table I am connecting to has over 100 million records. I want to filter this down to only the records I need for my dashboard before it is loaded into PowerBI, but the value I want to filter by does not show up in the preview.