Lets start with unzipping it into a folder.
List of tables or fields used to create a calculation (calculated table, column, or measure).
Look at below Power expedition escape coupon code BI Model; There are 29 tables in the list above, 270 win case length and each of those tables also has tens of fields in it!For now, you have to do that check manually.Power BI Helper is a tool key rewards card that finds all tables and fields that are used in the visualization and reporting side.The tool that I am introducing is created by radacad team, and this is the very first version of this product.For example the culture, versioning, and some other configurations.For this blog post, my focus is on M script section of that.When the application is opened, click on Select Power BI File; Select the *.pbix file here, and then you will see list of all fields used in visualization section of reports; Also; if you go to Insight tab, you will see the list of Tables.Here is the actual Power Querys Query Editor list: all of these queries, parameters, and functions are in the section1.m file.
What Power BI Helper version.1 Does?
Finding Tables/Fields that are used in Visualizations.
However, if you have many queries and you want a way to get the script of all of them then this post is for you.DataMashup: This is the file which is main topic of this blog post.Not all of these tables and fields are used in the reporting!This tool is built by radacad team and licensed free to use at the moment.Lets look at that.So, very easily you can access all queries pane from this area.
Some of these limitations which will be added as feature in next versions of Power BI helper are; List of fields used in the Filter area.
Xml, which is the information about settings of Power Query.
Summary, in this post, I introduced a tool to you that saves you some time for cleaning up a Power BI report.