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...
Hi sdoggett ,
I doubt you miss the step shown below...Please kindly check the data type of the type and column_to_filter_on columns are number. And you could see the output by clicking the each applied steps.
#"Changed Type" = Table.TransformColumnTypes(Source,{{"type", Int64.Type}, {"column_to_filter_on", Int64.Type}})
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
The type and column_to_filter_on fields were imported as numbers, so this is not the problem.