In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. This blog posts teaches you how to split columns.
In this blog series, we’ll explore some easy ways to reduce the size of a Power BI model. In this blog post I will tell you why you should remove some fields.
In our previous blog post, we explained how we can use VertiPaq Analyzer to analyse the amount of memory our model needs. This memory is also linked to the speed with which the model calculates and refreshes data. In this blog series, we’ll discuss several ways to limit this memory usage.
One of the things you could do to refresh your data quicker and speed up calculations is resizing the data model. But how do you even figure out the current size of your data model? Is it the same as its file size?
In the past, a new version of Microsoft Office was released every few years. Office 365 is different: it only has one version, which is updated regularly. Whenever a new Office version came out, we – as trainers – were curious to see the new functionalities Microsoft had integrated into the software. It made us wonder: “What will Microsoft come up with next time?” Well, they’ve still got plenty of inspiration!
Sometimes a small tip can make a world of difference. The tip in this post is one of those. If you use Excel regularly, you will probably create tables from time to time. And, if you often enter functions, you probably make your formulas more readable by using cell names. If, several months later, you need to make any changes to the workbook, you might not remember the exact name of the cell or table, or...
Are you exploring Office 365 and do you have any questions about the software that need answering? Book one of our virtual workshops today. We’ll help you and your co-workers get up and running with Teams, Power BI, Power Automate, Project Online Professional, and other tools.
Subscribe for our monthly newsletter and receive: