If you have a Power BI file for a while, you realize the model gets bigger and bigger. Not only the file size but also the number of pages, tables, fields. You will get to some steps that it would be really hard to find which tables and fields are useful and which are not. Read more about Power BI File Clean-up In a Few Steps[…]
The Power BI related activity in your organization can be often useful. You can use the activity (audit) log to determine the behavior of the users and enhance the adoption of Power BI in your organization. To get the audit log, however, the process isn’t simplified yet. In this article and video I show you Read more about Export Power BI Audit log in a few Simple Steps with No Code[…]
Previously I explained how you can document a single Power BI file. Another very common documentation requirement is to find out what objects, workspaces exist in the Power BI tenant and document them all. even you may want to download all the PBIX files from the service and keep it for versioning purposes. In this Read more about Document the Power BI Tenant objects: Workspace, reports, datasets, dataflows with no code[…]
One of the performance considerations of a Power BI file is to reduce the size of it as much as possible. This also helps with the speed of development, because smaller files loads faster and easier in the Power BI Desktop. One way to reduce the size significantly is to find which columns are consuming Read more about How to Reduce the Size of Power BI file in a few Steps[…]
If you want to export the data of a Power BI table, you have options such as copy and paste, or putting it in a visual and export it. However, there is an easier way available too. You can use Power BI Helper (free tool) to export the entire data of the table. The instruction Read more about Export the Data of a Power BI table entirely in a few Clicks[…]
In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals Read more about Document a Power BI file and report in a few clicks: all DAX code, visualization, Power Query scripts[…]
Happy New Year. We wish this be a year full of happiness and joy for all of you. We are glad to let you know that version 12 of Power BI Helper is now available to download with the below new features; Detecting the storage mode of tables (DirectQuery, Dual, Import) Detecting the connection mode Read more about Power BI Helper Version 12 (2021) Feature Summary[…]
At the end of the year 2020, we have a gift for you. Version 11 of Power BI helper has some amazing new features as below; Documentation Customization of the style Customization of the items to be exported Formatting DAX expressions in the document List of all visuals for every page Showing the measure dependency Read more about Power BI Helper Version 11 Feature Summary[…]
December 2019 is a major update in Power BI Helper. We believe this is the biggest update we have done so far. The list of updates is big. To name a few, now we have pages, visuals and bookmarks metadata available, visual comparer, visualization tree, the reverse dependency tree, DMV execution page, and dependant calculations Read more about Power BI Helper December 2019 Feature Summary[…]
How many times you have been thinking to see is this possible to store the data of the Power BI report every day, every week or month. How many times, you thought of how to take a snapshot of the data in the Power BI dataset or report at a specific point of times? Well, Read more about Scheduled Snapshot of the Power BI Data and Report[…]