In this tutorial, you’ll learn how to remove a hidden date table in Power BI to reduce RAM usage and improve performance. Power BI automatically creates hidden date tables when you have the Auto date/time option enabled. To enable the Auto date/time, go to Options and then to the Data Load tab. Under the Time
Tag: Power BI Optimization
In this tutorial, you’ll learn a Power Query optimization technique to reduce RAM usage. Specifically, you’ll learn how to reduce the numbers stored after a decimal place. This is helpful if you’re dealing with columns stored in a decimal number format. In this example, you can see that the Net Price is consuming 11MB of
This tutorial will discuss context transition and nested Iterators. You’ll learn the importance of these entities and how they can be a good source for optimization. If you recall, context transition happens when a row context changes into an equivalent filter context. You need to be aware of what’s happening when a context transition occurs
This tutorial will discuss about DAX query optimization practices. You’ll learn what VertiPaq can do with caches to improve DAX performance and generate accurate results. VertiPaq Caches In DAX Calculations The first topic is the VertiPaq Cache. Before you run your queries, you have to clear the cache first because other users may not use
This tutorial will discuss about CallBackDataID, which is a performance issue in DAX Studio. You’ll learn what it does and how it affects the performance of your DAX query. The storage engine works to provide data to the formula engine in the form of a data cache. But when the storage engine is unable to