Tag: Power BI Performance

Removing A Hidden Date Table In Power BI To Improve Performance

Removing A Hidden Date Table In Power BI To Improve Performance - Enterprise DNA

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

Continue reading

Power Query Optimization: Reducing Decimal Numbers

Power Query Optimization Reducing Decimal Numbers - Enterprise DNA

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

Continue reading

Comprehensive Manufacturing Operations Report In Power BI

Comprehensive Manufacturing Operations Report In Power BI

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

Continue reading