Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
1 year ago

need some dax or logic

Hi All,   Every month I used to download one excel data from one of the work tracker tool. This excel download i took every monday and the same excel sheet I upload in power bi in table. Now on tha...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi PowerBIBeginer 

Power BI reads data directly from the source and does not store previously generated random values. Those 22 records will always reappear after each refresh if they are present in the source. The records that need to be excluded must be tracked or stored somewhere and then fed back into the model as a reference for exclusion.

 

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
1 year ago

Could you help me then how do I get those excluded when every time I do raw dump refresh?

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Do you already have a separate data source that tracks those records already included in the prior quality check? Without that, there's no way to exclude them.