You may also want to remove tables that are not used as well. However, It will remove it from the list of fields in the Report tab, and avoid confusion for report developer. Hiding a table does not remove it from the model. This means you can easily right click and hide all other tables. Only tables that you see in the list above are used in reporting section.
SIZE OF POWER BI DOWNLOAD HOW TO
You can see only 10 out of the 29 tables are used in the Power BI report! How to Use This Result So Problem Solved! Now you have the list of tables that are used in the report. These are tables that at least one of their fields used in any of reports (for visualization or even for filtering) Select the *.pbix file here, and then you will see list of all fields used in visualization section of reports Īlso if you go to Insight tab, you will see the list of Tables that are used in the report. When the application is opened, click on Select Power BI File
SIZE OF POWER BI DOWNLOAD DOWNLOAD
You can download it from this link: Download Power BI HelperĪfter installing the Power BI Helper, Open Power BI Helper either from your Desktop, or Programs.
SIZE OF POWER BI DOWNLOAD FREE
Instead of clicking on every single visual and finding out that which tables are not used at the end, this tool does that for you very fast! This tool is built by RADACAD team and licensed free to use at the moment. Power BI Helper is a tool that finds all tables and fields that are USED in the visualization and reporting side. However, when you have 20+ report pages, and on each page, you have 6+ charts, then it is taking you a lot of time to do so! So, now the problem is įinding tables/fields that are used in the visualization (or reporting) Introducing a Tool: Power BI Helper At the moment in Power BI Desktop to find which fields are used in a visual, you can click on the visual, and you will see tables highlighted on the right-hand side, so it means these tables and fields are used in the visual. Normally when I see a model like above, the first action I take is to look at tables that are not used to remove them, or at least hide them. 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. 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)
