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[…]