Data doesn't show in data view but is in Power Query

After filtering in Power Query, check if you have any later steps that might be dropping rows. For example, if you filter first by a specific provider name and then remove duplicates on the Department column, the row for that provider will be kept because the filter makes it the only one left for that department. But if the filter is not applied before removing duplicates, Power Query will keep the first department record it finds, which might belong to a different provider.