Forum Discussion

craigpowell's avatar
craigpowell
Regular Visitor
8 years ago
Solved

Data refresh filter too slow

Hi All,   Very new (first post) to PowerBI, M and Dax.  I am trying to filter at data refresh the lines included in the data load based on whether a value in one column exists in another column in...
  • MattAllington's avatar
    MattAllington
    8 years ago
    1. create a new query pointing to StatePostcode (call it Postcodes)
    2. Remove all colums other thatn postcode
    3. remove duplicates
    4. Set so it doesn't load.

     

    1. create a merge query starting with Address and join to Postcodes query from above
    2. left outer join
    3. expan the columns to extract the postcode from Postcodes.
    4. Filter on the new column where [postcode] <> null
    5. remove the extra postcode column.

    you are done

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
8 years ago
  1. create a new query pointing to StatePostcode (call it Postcodes)
  2. Remove all colums other thatn postcode
  3. remove duplicates
  4. Set so it doesn't load.

 

  1. create a merge query starting with Address and join to Postcodes query from above
  2. left outer join
  3. expan the columns to extract the postcode from Postcodes.
  4. Filter on the new column where [postcode] <> null
  5. remove the extra postcode column.

you are done

  • craigpowell's avatar
    craigpowell
    Regular Visitor
    8 years ago

    Cheers Matt.

     

    Worked perfectly!