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 Performance
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 Power BI Showcase will focus on a comprehensive manufacturing operations report that effectively presents the overall performance of a product-inclined business. You may watch the full video of this tutorial at the bottom of this blog. Particularly, we’ll be using a business model that manufactures parts for airplane wings. We’re going to look at