2/27/2023 0 Comments Why does my browser so slow![]() If you are doing 70- transformations then creating 3 DIM tables, those 3 DIM tables force the full 70 transformations to run each time. I would also like to see how your FACT table is being split off into DIM tables. It really comes down to optimizing the code so steps are repeated as little as possible. ![]() ![]() I'm not clear on what you mean by the steps are still registered. Is there a better solution to solve my issue in Power BI, so that I can avoid doing all those steps (or at least don't mess up the performance of Power BI. Thanks for the tip! So what would you advice to a beginner like me when working with such datasets? Because when I duplicate the fact table and remove other columns to create a dimension table, all the previous steps are still registered. ![]() Those steps go through all 100,000 rows every single time." I did not know that. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |