Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a situation where my refresh fails because users put bad data.
I would prefer if refresh continues and drops all duplicate entries after the first entry is found. It would be nice if I get a warning via some email notification.
Is this possible? One bad data entry kills the entire report and makes it unusable.
@tvaishnav Perhaps just add a remove duplicates step to your query?
Thanks for pointing that out. But that will remove the data and not really inform anyone about the problem.