Optimizing Energy BI semantic mannequin doesn’t at all times need to be a frightening and time-consuming job. You’ll be able to usually have fun many fast and straightforward wins!
A number of weeks in the past, I used to be tasked with optimizing a slow-performing Energy BI report. In fact, there might be dozens of explanation why your Energy BI report performs gradual, however on this put up, I need to share with you the “low-hanging fruit” and how one can considerably enhance Energy BI semantic fashions by making use of some quite simple optimization strategies.
For demo functions, I’ll be utilizing a truth desk that comprises the info about chats carried out by a buyer help division of the fictional firm Buyer First. This desk contains roughly 9 million rows, which isn’t thought-about a big desk within the context of Energy BI and analytical workloads. For the sake of simplicity, let’s faux that our mannequin consists of solely this single desk. Lastly, a semantic mannequin is configured as an Import mode mannequin. If you wish to find out how your knowledge is saved in Energy BI, I recommend you begin by studying this text first.