In the third part of my blog series on Performance, this time I am going to see how Row Level Security will affect performance. RLS is an awesome feature when you want to ensure that only the relevant people can view their data and not see other data. Row Level Security (RLS) is where I can create roles which can…

In the third part of my blog series on Performance, this time I am going to show how a data refresh can affect performance. Below are the high-level steps as to what happens when you refresh a dataset The first step is it creates a blank copy of your existing dataset. It then loads all the updated data into this…

In the second part of my blog series on Performance I am going to show how to look to potentially optimize your Power BI Model. The biggest impact you can have to the performance of your model is if you can reduce the size of the model, it just means that everything will run that much faster, process quicker and…