This sample report also has 20+ report pages!įinding Tables/Fields that are used in Visualizations So the problem is cleaning up the model, and your Power BI report might already have more than 20 report pages. Not all of these tables and fields are used in the reporting! This Data Model needs clean up. The problem is that not all of these tables and fields are used in the reporting! Especially if you just introduced to a project, and you see such a complicated model.
It is nightmare, isn’t it?! You never want to maintain such a model. There are 29 tables in the list above, and each of those tables also has tens of fields in it! It gets even worse when you look at the relationship model However, More tables will make things more complicated and confusing. The worst thing about this is that not all of those tables are used in the report! Many people think that having more tables in your model is better because it enables them to analyze data based on every field they want. Despite the fact that I always recommend preparing your data to be modeled and bring only what needed, still I see many Power BI reports that has hundreds of tables in it. You have a Power BI file that has 50, or even 100 tables in it.
Power bi tools download#
The tool is free to use, and you can download it from below link. The tool that I am introducing is created by RADACAD team, and this is the very first version of this product. In this post, I’m going to share a tool that I use myself that saves you time (and as a result money) to clean up your Power BI report much faster. It will take lots of time to find out if all of those 50 tables actually used in reports and visualization or not. When Power BI file gets in that size, maintenance is always an issue. You can have 50 tables in a Power BI model, and 25 reports.
0 kommentar(er)
