Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to Remove Duplicate Values from PowerBI Direct Query Table

Hi,  I brought in a table from SQL database using DirectQuery (needed to solution a PowerApp inside the PBI visual). The PBI visual is a table listing projects, each project has multiple attributes...
Need Help
  • mahoneypat's avatar
    mahoneypat
    3 years ago

    For long term, I would talk to your DBA to get the data in the format you need. In the short term, if you can't switch to import mode (recommended to get the flexibilty you need and improve performance), you can use the SUMMARIZE function in your measures to get the distinct combination of the fields you need (e.g., leave out the Director field).

     

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
3 years ago

For long term, I would talk to your DBA to get the data in the format you need. In the short term, if you can't switch to import mode (recommended to get the flexibilty you need and improve performance), you can use the SUMMARIZE function in your measures to get the distinct combination of the fields you need (e.g., leave out the Director field).

 

Pat

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Pat. I think I will go with the DBA route, it seems cleaner. Thanks again!