title
2 ways to reduce your Power BI dataset size and speed up refresh

description
Adam shows you two things to reduce your Power BI dataset size. These are both things he commonly sees with Power BI reports and could potentially save you a lot of space and improve refresh times along with report performance. Data reduction techniques for import modeling: https://docs.microsoft.com/power-bi/guidance/import-modeling-data-reduction ******** LET'S CONNECT! ******** -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.com/patrickdba -- http://www.facebook.com/guyinacube -- https://www.instagram.com/guyinacube/ -- https://guyinacube.com ***Gear*** Check out my Tools page - https://guyinacube.com/tools/ #PowerBI #DataModeling #PowerBIDataset

detail
{'title': '2 ways to reduce your Power BI dataset size and speed up refresh', 'heatmap': [{'end': 119.061, 'start': 93.701, 'weight': 0.748}, {'end': 293.232, 'start': 215.651, 'weight': 0.71}], 'summary': 'Learn model performance tips and practical insights for optimizing power bi desktop, reducing file size, utilizing free tools like dax studio and vertipaq analyzer, and optimizing the vertipaq engine to reduce model size from 600 meg to 74 meg and improve refresh time from almost an hour to about eight minutes, potentially enhancing report performance.', 'chapters': [{'end': 48.162, 'segs': [{'end': 48.162, 'src': 'embed', 'start': 0.109, 'weight': 0, 'content': [{'end': 2.491, 'text': "Yo, I'm Saxon with Guy in a Cube.", 'start': 0.109, 'duration': 2.382}, {'end': 11.378, 'text': 'Is your model too big? Is your report kind of sluggish and too slow? Is your refresh taking too long? Have I got the answer for you.', 'start': 2.851, 'duration': 8.527}, {'end': 14.781, 'text': 'Introducing the new revolutionary Magic Model Powder.', 'start': 11.639, 'duration': 3.142}, {'end': 17.383, 'text': 'Introducing Magic Model Spray.', 'start': 15.001, 'duration': 2.382}, {'end': 19.785, 'text': 'Maybe puppers drool can help you with your model.', 'start': 17.403, 'duration': 2.382}, {'end': 23.148, 'text': "Come on guys, who are we kidding? There's some work to be done.", 'start': 19.966, 'duration': 3.182}, {'end': 23.849, 'text': "Let's get into it.", 'start': 23.268, 'duration': 0.581}, {'end': 34.385, 'text': "If you're finding us for the first time, be sure to hit that subscribe button to stay up to date with all the videos from both Patrick and myself.", 'start': 28.598, 'duration': 5.787}, {'end': 39.251, 'text': 'Model performance and refresh and all this stuff.', 'start': 35.807, 'duration': 3.444}, {'end': 46.319, 'text': "I've been working with some customers and we found some great tips and tricks for how you can actually go identify these items.", 'start': 39.611, 'duration': 6.708}, {'end': 48.162, 'text': 'And I wanted to share a few of those with you.', 'start': 46.38, 'duration': 1.782}], 'summary': 'Saxon with guy in a cube introduces tips for improving model performance and refresh time.', 'duration': 48.053, 'max_score': 0.109, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc109.jpg'}], 'start': 0.109, 'title': 'Model performance tips', 'summary': 'Introduces tips for improving model performance and refresh time, emphasizing the need for optimization and sharing practical insights.', 'chapters': [{'end': 48.162, 'start': 0.109, 'title': 'Model performance tips', 'summary': 'Introduces tips and tricks for improving model performance and refresh time, highlighting the need for optimization and sharing practical insights.', 'duration': 48.053, 'highlights': ['The chapter introduces practical tips for improving model performance and refresh time, emphasizing the need for optimization (e.g., sluggish reports, slow refresh) and sharing customer-derived insights.', 'The speaker promotes the importance of subscribing for staying updated on videos covering model performance and refresh.', "The chapter humorously mentions 'Magic Model Powder' and 'Magic Model Spray' as solutions for model performance issues, creating a light-hearted atmosphere before delving into the actual tips and tricks."]}], 'duration': 48.053, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc109.jpg', 'highlights': ['Introduces practical tips for improving model performance and refresh time, emphasizing the need for optimization and sharing customer-derived insights.', 'Promotes the importance of subscribing for staying updated on videos covering model performance and refresh.', "Humorously mentions 'Magic Model Powder' and 'Magic Model Spray' as solutions for model performance issues, creating a light-hearted atmosphere before delving into the actual tips and tricks."]}, {'end': 475.064, 'segs': [{'end': 119.061, 'src': 'heatmap', 'start': 88.235, 'weight': 2, 'content': [{'end': 91.54, 'text': 'In this case, I put some text on here, this page left blank intentionally.', 'start': 88.235, 'duration': 3.305}, {'end': 93.661, 'text': 'This is so I can avoid the visual cache.', 'start': 91.82, 'duration': 1.841}, {'end': 97.362, 'text': "So once I add that blank page, I'll save it, close it, reopen it.", 'start': 93.701, 'duration': 3.661}, {'end': 102.204, 'text': 'Then what I wanna do is go to the View tab and turn on Performance Analyzer.', 'start': 97.582, 'duration': 4.622}, {'end': 103.544, 'text': 'This should be your first stop.', 'start': 102.424, 'duration': 1.12}, {'end': 105.385, 'text': "Let's just see how things run.", 'start': 103.584, 'duration': 1.801}, {'end': 108.946, 'text': "So I'll hit Start Recording, and then I'll go over to the actual report page.", 'start': 105.405, 'duration': 3.541}, {'end': 112.977, 'text': 'And then this will go and do its thing and render those visuals.', 'start': 110.595, 'duration': 2.382}, {'end': 119.061, 'text': 'So, okay, they came up, you know, took a little, a couple seconds on the, it looked like a couple seconds on Mr. Spinney.', 'start': 113.097, 'duration': 5.964}], 'summary': 'Using performance analyzer to optimize report page load time.', 'duration': 30.826, 'max_score': 88.235, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc88235.jpg'}, {'end': 172.051, 'src': 'embed', 'start': 139.996, 'weight': 4, 'content': [{'end': 142.938, 'text': 'But looking at DAX and visual, everything looks OK.', 'start': 139.996, 'duration': 2.942}, {'end': 145.199, 'text': 'Nothing that really sends alarms to me.', 'start': 143.258, 'duration': 1.941}, {'end': 149.681, 'text': 'And so from this standpoint, the report performance is kind of OK.', 'start': 145.739, 'duration': 3.942}, {'end': 154.384, 'text': "Let's pretend that they actually came to us and said, hey, the real issue is my refresh is slow.", 'start': 149.922, 'duration': 4.462}, {'end': 157.346, 'text': 'It may be that report performance is slow as well.', 'start': 155.084, 'duration': 2.262}, {'end': 161.307, 'text': 'and you may see, like high dax query numbers or things of that nature,', 'start': 158.326, 'duration': 2.981}, {'end': 166.429, 'text': "that signal that maybe we've got some data model issue or dax optimization that we can go do.", 'start': 161.307, 'duration': 5.122}, {'end': 172.051, 'text': "and so, from a refresh perspective, if we could jump over to the service and look, one thing we'll see is we'll see some areas here,", 'start': 166.429, 'duration': 5.622}], 'summary': 'Dax and visual look ok, no alarming issues, report performance kind of ok, potential data model or dax optimization needed for slow refresh.', 'duration': 32.055, 'max_score': 139.996, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc139996.jpg'}, {'end': 246.514, 'src': 'embed', 'start': 215.651, 'weight': 0, 'content': [{'end': 221.236, 'text': "it's a model optimization exercise and, or you know, optimizing DAX itself.", 'start': 215.651, 'duration': 5.585}, {'end': 226.18, 'text': "There's a lot of stuff you can do in terms of optimizing to get things to perform way better.", 'start': 221.476, 'duration': 4.704}, {'end': 228.642, 'text': "All right, so let's start with DAX Studio.", 'start': 226.2, 'duration': 2.442}, {'end': 236.767, 'text': 'So both of these tools, DAX Studio and VertiPaq Analyzer are available for free over at sqlbi.com, shout out to Marco and Alberto.', 'start': 228.942, 'duration': 7.825}, {'end': 246.514, 'text': "And when we're in DAX Studio, we're gonna wanna select PBI SSDT model, choose the dropdown and choose our Power BI desktop file or model, hit connect.", 'start': 237.548, 'duration': 8.966}], 'summary': 'Optimize dax and model performance using dax studio and vertipaq analyzer.', 'duration': 30.863, 'max_score': 215.651, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc215651.jpg'}, {'end': 293.232, 'src': 'heatmap', 'start': 215.651, 'weight': 0.71, 'content': [{'end': 221.236, 'text': "it's a model optimization exercise and, or you know, optimizing DAX itself.", 'start': 215.651, 'duration': 5.585}, {'end': 226.18, 'text': "There's a lot of stuff you can do in terms of optimizing to get things to perform way better.", 'start': 221.476, 'duration': 4.704}, {'end': 228.642, 'text': "All right, so let's start with DAX Studio.", 'start': 226.2, 'duration': 2.442}, {'end': 236.767, 'text': 'So both of these tools, DAX Studio and VertiPaq Analyzer are available for free over at sqlbi.com, shout out to Marco and Alberto.', 'start': 228.942, 'duration': 7.825}, {'end': 246.514, 'text': "And when we're in DAX Studio, we're gonna wanna select PBI SSDT model, choose the dropdown and choose our Power BI desktop file or model, hit connect.", 'start': 237.548, 'duration': 8.966}, {'end': 251.137, 'text': "And then what we're gonna see in the lower right is localhost colon port number.", 'start': 247.174, 'duration': 3.963}, {'end': 253.859, 'text': 'So this is our connection string to our model.', 'start': 251.217, 'duration': 2.642}, {'end': 257.421, 'text': 'armed with that, we can go to VertiPaq analyzer.', 'start': 254.799, 'duration': 2.622}, {'end': 258.922, 'text': 'so let me jump over to my files.', 'start': 257.421, 'duration': 1.501}, {'end': 264.525, 'text': 'VertiPaq analyzer is just an excel file, but it comes pre-configured with a bunch of stuff,', 'start': 258.922, 'duration': 5.603}, {'end': 270.489, 'text': "and so what we want to do here is you may have to enable some things because there's some custom scripts and whatnot.", 'start': 264.525, 'duration': 5.964}, {'end': 274.091, 'text': "but once you're in, go to the data tab, manage the data model.", 'start': 270.489, 'duration': 3.602}, {'end': 279.975, 'text': 'this will take us into power pivot for excel and then what we need to do is go to existing connections.', 'start': 274.091, 'duration': 5.884}, {'end': 286.268, 'text': "we'll go and edit that ssas connection hit build, And then this is where we're gonna put in that port number.", 'start': 279.975, 'duration': 6.293}, {'end': 290.311, 'text': 'So come in, go ahead and hit okay.', 'start': 286.348, 'duration': 3.963}, {'end': 293.232, 'text': 'We need to choose the dropdown to make sure we choose our data model.', 'start': 290.611, 'duration': 2.621}], 'summary': 'Optimizing dax using dax studio and vertipaq analyzer for better performance.', 'duration': 77.581, 'max_score': 215.651, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc215651.jpg'}, {'end': 355.596, 'src': 'embed', 'start': 328.282, 'weight': 1, 'content': [{'end': 333.725, 'text': "And if we look, some of these are not insignificant, like they've got some heft to them.", 'start': 328.282, 'duration': 5.443}, {'end': 335.046, 'text': 'A bunch of them are pretty small.', 'start': 333.745, 'duration': 1.301}, {'end': 339.308, 'text': "So this is the first tip I'm gonna have for you, which is disable auto date time.", 'start': 335.666, 'duration': 3.642}, {'end': 344.951, 'text': 'You should have a date table in your model that can handle all of your date slicing and dicing needs.', 'start': 339.628, 'duration': 5.323}, {'end': 347.853, 'text': "So let's go back into Power BI Desktop real quick.", 'start': 345.911, 'duration': 1.942}, {'end': 348.393, 'text': "We'll show that.", 'start': 347.873, 'duration': 0.52}, {'end': 349.795, 'text': "We'll go to File, Options.", 'start': 348.413, 'duration': 1.382}, {'end': 352.257, 'text': 'Go into Options.', 'start': 351.396, 'duration': 0.861}, {'end': 355.596, 'text': 'It can be two items here.', 'start': 354.616, 'duration': 0.98}], 'summary': 'Power bi tip: disable auto date time and use date table for efficient date slicing and dicing.', 'duration': 27.314, 'max_score': 328.282, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc328282.jpg'}], 'start': 48.462, 'title': 'Optimizing power bi performance', 'summary': 'Discusses optimizing performance in power bi desktop and explores the process of optimizing power bi performance, including identifying areas for improvement, such as slow refresh and model optimization. it also includes tips for reducing file size and utilizing free tools like dax studio and vertipaq analyzer.', 'chapters': [{'end': 119.061, 'start': 48.462, 'title': 'Optimizing power bi desktop performance', 'summary': 'Discusses optimizing performance in power bi desktop, including opening a blank page to avoid visual cache, using performance analyzer, and analyzing report rendering time.', 'duration': 70.599, 'highlights': ['Opening a blank page in Power BI Desktop to avoid visual cache can help improve performance by preventing caching of visuals and providing a more accurate performance assessment.', "Using Performance Analyzer as the first step to analyze the report's performance enables identification of potential bottlenecks and optimization opportunities.", 'Analyzing report rendering time by recording and analyzing the time taken for visuals to render provides insights into the performance of the report and helps in identifying areas for improvement.']}, {'end': 475.064, 'start': 119.081, 'title': 'Optimizing power bi performance', 'summary': 'Explores the process of optimizing power bi performance, including identifying areas for improvement, such as slow refresh and model optimization, and utilizing free tools like dax studio and vertipaq analyzer to improve report performance and reduce file size.', 'duration': 355.983, 'highlights': ['Using DAX Studio and VertiPaq Analyzer to identify areas for improvement The chapter emphasizes the use of DAX Studio and VertiPaq Analyzer to analyze DAX queries, model optimization, and reduce file size, providing actionable insights for performance improvement.', 'Identifying and addressing slow refresh and model optimization issues The speaker discusses identifying slow refresh and model optimization issues, providing insights on optimizing DAX and data model to improve report performance.', 'Disabling auto date time to reduce file size and improve performance The chapter provides a step-by-step guide on disabling auto date time to reduce file size, streamline the data model, and improve overall Power BI performance.']}], 'duration': 426.602, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc48462.jpg', 'highlights': ['Using DAX Studio and VertiPaq Analyzer to identify areas for improvement The chapter emphasizes the use of DAX Studio and VertiPaq Analyzer to analyze DAX queries, model optimization, and reduce file size, providing actionable insights for performance improvement.', 'Disabling auto date time to reduce file size and improve performance The chapter provides a step-by-step guide on disabling auto date time to reduce file size, streamline the data model, and improve overall Power BI performance.', 'Analyzing report rendering time by recording and analyzing the time taken for visuals to render provides insights into the performance of the report and helps in identifying areas for improvement.', "Using Performance Analyzer as the first step to analyze the report's performance enables identification of potential bottlenecks and optimization opportunities.", 'Identifying and addressing slow refresh and model optimization issues The speaker discusses identifying slow refresh and model optimization issues, providing insights on optimizing DAX and data model to improve report performance.', 'Opening a blank page in Power BI Desktop to avoid visual cache can help improve performance by preventing caching of visuals and providing a more accurate performance assessment.']}, {'end': 1043.133, 'segs': [{'end': 516.27, 'src': 'embed', 'start': 490.474, 'weight': 2, 'content': [{'end': 496.498, 'text': 'And when we look at VertiPaq Analyzer, one table screams at us, which is the sales column, and we see 25 million there.', 'start': 490.474, 'duration': 6.024}, {'end': 505.444, 'text': "My initial thoughts when I'm looking at this is well, we probably have an identity column that's just got a bunch of unique values in it right?", 'start': 498.92, 'duration': 6.524}, {'end': 507.485, 'text': 'So ID columns are used for relationships.', 'start': 505.504, 'duration': 1.981}, {'end': 516.27, 'text': "And this one is actually probably we have an ID field on the sales table that's individual unique entries, and there's 25 million of them.", 'start': 508.166, 'duration': 8.104}], 'summary': 'Vertipaq analyzer identifies 25 million unique entries in the sales table, likely due to an individual id field.', 'duration': 25.796, 'max_score': 490.474, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc490474.jpg'}, {'end': 703.34, 'src': 'embed', 'start': 674.733, 'weight': 3, 'content': [{'end': 678.134, 'text': 'So our sales order number, our online sales key, and our order ID.', 'start': 674.733, 'duration': 3.401}, {'end': 680.574, 'text': "So there's no relationships there at all.", 'start': 678.214, 'duration': 2.36}, {'end': 682.195, 'text': 'So why do we need them??', 'start': 680.654, 'duration': 1.541}, {'end': 684.035, 'text': 'Are we actually going to report on them??', 'start': 682.655, 'duration': 1.38}, {'end': 689.196, 'text': "One thing I've heard from folks is well, you know, I want to use this column to get a row count.", 'start': 684.515, 'duration': 4.681}, {'end': 692.257, 'text': 'No, no, no.', 'start': 691.057, 'duration': 1.2}, {'end': 694.778, 'text': "You don't need that field to do row count.", 'start': 692.917, 'duration': 1.861}, {'end': 699.219, 'text': "I can do count rows and it'll just count rows, right? It doesn't matter what columns there.", 'start': 694.818, 'duration': 4.401}, {'end': 699.879, 'text': 'All right.', 'start': 699.239, 'duration': 0.64}, {'end': 703.34, 'text': "So with that, let's clean this up a little bit, right? So let's get rid of..", 'start': 699.899, 'duration': 3.441}], 'summary': 'Discussion on the necessity of certain fields in sales data for reporting and row count.', 'duration': 28.607, 'max_score': 674.733, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc674733.jpg'}, {'end': 778.716, 'src': 'embed', 'start': 752.759, 'weight': 4, 'content': [{'end': 759.327, 'text': "and typically what I find is folks don't necessarily do the work to really pick and choose what are those columns that we need to bring in.", 'start': 752.759, 'duration': 6.568}, {'end': 765.193, 'text': "A big, big, big thing you can do to improve performance is don't pull in columns you don't need.", 'start': 759.347, 'duration': 5.846}, {'end': 767.393, 'text': 'This ID columns are an example of it.', 'start': 765.373, 'duration': 2.02}, {'end': 769.814, 'text': "So if you're not doing relationships on them, get rid of them.", 'start': 767.433, 'duration': 2.381}, {'end': 770.514, 'text': "You don't need them.", 'start': 769.834, 'duration': 0.68}, {'end': 771.774, 'text': "You're not gonna report on those.", 'start': 770.534, 'duration': 1.24}, {'end': 775.555, 'text': 'The only one I could probably argue on is that sales order number.', 'start': 771.974, 'duration': 3.581}, {'end': 778.716, 'text': 'Like, cause maybe that, you know, or some sort of invoice ID.', 'start': 775.915, 'duration': 2.801}], 'summary': 'Avoid pulling unnecessary columns to improve performance, except for essential ones like sales order number or invoice id.', 'duration': 25.957, 'max_score': 752.759, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc752759.jpg'}, {'end': 977.988, 'src': 'embed', 'start': 928.338, 'weight': 0, 'content': [{'end': 934.522, 'text': "It's like just lost almost all of it just because of those columns that we didn't even use,", 'start': 928.338, 'duration': 6.184}, {'end': 940.126, 'text': 'primarily those ID columns that we were using in this model that we had no use for.', 'start': 934.522, 'duration': 5.604}, {'end': 944.649, 'text': "So getting rid of those cleared this up a lot, and I've seen this at customers too,", 'start': 940.226, 'duration': 4.423}, {'end': 949.673, 'text': 'where we just remove that one column and it just drastically improves the model size.', 'start': 944.649, 'duration': 5.024}, {'end': 952.955, 'text': 'as a result, the refresh times a lot faster too.', 'start': 949.673, 'duration': 3.282}, {'end': 955.797, 'text': "so let's go back over to the service and we'll compare.", 'start': 952.955, 'duration': 2.842}, {'end': 958.519, 'text': 'so that was looking at the the large one.', 'start': 955.797, 'duration': 2.722}, {'end': 960.42, 'text': 'you know it took almost an hour.', 'start': 958.519, 'duration': 1.901}, {'end': 964.704, 'text': 'if we go back and look at the refresh history here, look at that about eight minutes.', 'start': 960.42, 'duration': 4.284}, {'end': 966.196, 'text': "That's insane.", 'start': 965.555, 'duration': 0.641}, {'end': 967.137, 'text': 'Same model.', 'start': 966.396, 'duration': 0.741}, {'end': 977.988, 'text': 'we just remove the unused columns and bam refresh is faster, model size is a lot lower and we are potentially improving report performance as well,', 'start': 967.137, 'duration': 10.851}], 'summary': 'Removing unused columns drastically improved model size and refresh time, from almost an hour to about eight minutes.', 'duration': 49.65, 'max_score': 928.338, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc928338.jpg'}], 'start': 476.064, 'title': 'Optimizing power bi models', 'summary': 'Discusses optimizing the vertipaq engine by identifying high cardinality columns, evaluating the necessity of id columns, and removing unused columns, resulting in a reduction in model size from 600 meg to 74 meg, and improving refresh time from almost an hour to about eight minutes, potentially enhancing report performance.', 'chapters': [{'end': 787.521, 'start': 476.064, 'title': 'Optimizing vertipaq engine', 'summary': 'Discusses optimizing the vertipaq engine by identifying high cardinality columns, such as the sales column with 25 million unique entries, and the importance of evaluating the necessity of id columns and removing unnecessary columns to improve performance and reduce table size in power bi data models.', 'duration': 311.457, 'highlights': ['The sales column in the table has 25 million unique entries, contributing to the overall size of the table and potentially impacting compression and performance in the VertiPaq engine. 25 million unique entries in the sales column', 'Evaluating the necessity of ID columns, such as the online sales key and order ID, and considering their impact on table size and performance, as well as assessing the relevance of these columns for reporting purposes. Assessing the necessity of online sales key and order ID columns', 'Recommendation to remove unnecessary columns, especially high cardinality ID columns, to improve performance and reduce table size in Power BI data models. Removing unnecessary high cardinality ID columns to improve performance']}, {'end': 1043.133, 'start': 787.581, 'title': 'Optimizing power bi model', 'summary': 'Demonstrates the process of optimizing a power bi model by removing unused columns, resulting in a drastic reduction in model size from around 600 meg to 74 meg and improving refresh time from almost an hour to about eight minutes, potentially enhancing report performance as well.', 'duration': 255.552, 'highlights': ['Removing unused columns resulted in a reduction in model size from around 600 meg to 74 meg. The removal of unused columns led to a significant reduction in model size, demonstrating the impact of optimizing the Power BI model.', 'Improving refresh time from almost an hour to about eight minutes by removing unused columns. The removal of unused columns significantly improved the refresh time, showcasing the tangible benefits of optimizing the Power BI model.', 'Recommendations for using tools like VertiPaq Analyzer and DAX Studio for performance optimization. The speaker recommends utilizing tools like VertiPaq Analyzer and DAX Studio for performance optimization, emphasizing the importance of leveraging these tools for enhancing Power BI models.']}], 'duration': 567.069, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/c-ZqToc85Yc/pics/c-ZqToc85Yc476064.jpg', 'highlights': ['Removing unused columns resulted in a reduction in model size from around 600 meg to 74 meg.', 'Improving refresh time from almost an hour to about eight minutes by removing unused columns.', '25 million unique entries in the sales column potentially impacting compression and performance in the VertiPaq engine.', 'Assessing the necessity of online sales key and order ID columns for reporting purposes.', 'Recommendation to remove unnecessary high cardinality ID columns to improve performance.']}], 'highlights': ['Removing unused columns resulted in a reduction in model size from around 600 meg to 74 meg.', 'Improving refresh time from almost an hour to about eight minutes by removing unused columns.', 'Using DAX Studio and VertiPaq Analyzer to identify areas for improvement The chapter emphasizes the use of DAX Studio and VertiPaq Analyzer to analyze DAX queries, model optimization, and reduce file size, providing actionable insights for performance improvement.', 'Disabling auto date time to reduce file size and improve performance The chapter provides a step-by-step guide on disabling auto date time to reduce file size, streamline the data model, and improve overall Power BI performance.', 'Analyzing report rendering time by recording and analyzing the time taken for visuals to render provides insights into the performance of the report and helps in identifying areas for improvement.']}