Michael Lowden on 15 Apr 2024 14:41:52
I had a scenario where my product IDs grew beyond the allowable size of a number field. Power BI proceeded to treat these as independent dimensions however it crashed silently when displaying the new Product IDs. Instead of throwing an error when the numeric overflow occurred, Power BI silently just started displaying (blank) across my reports. This should've thrown an error instead of corrupting the data labels and putting the report into question. Any error would've alerted both my business users and myself to investigate instead of questioning the validity of the report.