There are many visualization options in Power BI and one of them is custom visuals. I personally do not use custom visuals that much and I found some setbacks in using them. However, depending on what custom visual you’ll use, you can potentially create an insightful report. 

We’ve just finished a difficult yet fulfilling 12th round for the Power BI Challenge, which was based on a transport and shipping dataset. This was probably one of the most difficult challenges we’ve had to date, and we’re very impressed with the participants’ in-depth analysis on their entries. 

Scenario1: When you modify the data structure in the data source, the refresh error occurs.
Scenario2: When you have pivot columns steps in query editor, the value in the data source has been modified, the refresh error occurs.