Forum Discussion
Report Builder - Duplicate records
In Power BI Desktop, there is a feature to remove duplicate rows. Is there a feature in Report Builder for the same?
No there is no remove duplicates feature in Report Builder. It's a different style of tool. You would either point your Report Builder report at a Power BI model which already had duplicates removed or you would need to structure your query in Report Builder in such a way that it dealt with any duplicates. (ie. using grouping or some similar approach depending on your data source)
1 Reply
- d_gosbellSuper User
No there is no remove duplicates feature in Report Builder. It's a different style of tool. You would either point your Report Builder report at a Power BI model which already had duplicates removed or you would need to structure your query in Report Builder in such a way that it dealt with any duplicates. (ie. using grouping or some similar approach depending on your data source)