Blog

Keep up-to-date with the latest Data Vizioner news and industry insights.

Data Vizioner Kicks Off 2019

18 April 2019 in Announcements

Less than a year after launching a beta version of Power BI Documenter, Data Vizioner is entering its next phase of growth with a new brand identity, a growing user base and an exciting pipeline of new features to be rolled out over the coming year.

“The past 9 months have been incredible for Data Vizioner. The uptake of our first product Power BI Documenter has far exceeded our initial expectations with people trying the product in over 20 countries and providing insights that are helping us better understand our users.”

Soheil Bakhshi, Data Vizioner Co-founder

Growing up

Whether you’re creating reports, or using them to make key business decisions, Data Vizioner instantly lets you see how they are built and gives you confidence that you can trust the data you are seeing.

Over the coming year Power BI Documenter functionality will continue to improve, including a complete overhaul of the user interface designed to better map to the way you work, whether you’re a developer building dashboards or using them to make key business decisions.

Pricing

During the beta launch of Power BI Documenter, access has been free – and we will continue to offer a free version of the Data Vizioner tools with our Starter package going forward to ensure everyone has access to essential tools that make your life as a Power BI user easier!

The start of the new year also means the introduction of a new Professional edition which will include all our latest enhancements, such as best practice features that not only offer you advice on how to improve your PBIT files, but also fix them for you at the click of a button! The Professional edition is available to new users today for US$49 per month with a 14 day free trial.

Existing users

Your support has helped us grow – and we want to acknowledge and thank you for your contribution to the Data Vizioner community! As a thank you, all users that started using Power Documenter before 1 April 2019 who upgrade to Professional before 15 May 2019 will be eligible for a discounted rate of US$29 per user, per month for the life of your account!

We want to minimise the impact of these changes on your business, so please get in touch if you have any questions or comments.

Spread the word

As an early adopter we really value your support and feedback. Please keep sending us your thoughts – the good, the bad and the ugly! We hope that you will continue to spread word about Data Vizioner to your colleagues and networks. As a startup, this is essential to our continued growth!

Power BI Documenter Xmas 2018 Release

18 December 2018 in Uncategorized
Power BI Documenter v2.8

We’re excited to announce that Power BI Documenter V2.8 (December 2018) has been released for public use. The new release of Power BI Documenter comes with new fascinating features that makes your lives even easier on your day-to-day Power BI engagements. We, at Data Vizioner, recognise the pain points for Power BI professionals who are involved with Power BI development, code reviewing, auditing, documentation and handover. This release would be our last one in 2018 so we added some of the most wanted and compelling features to the tool to be given away as our Christmas present to all of our users. We would like to take this opportunity to thank all of you for using Power BI Documenter and giving us your invaluable feedbacks during the past 6 months. During this time, we hit the 1,000 users milestone which is amazing.

What is new in December 2018 release?

Power BI Documenter 2.8 comes with amazing new features that can help individuals and organisations with their Power BI engagements:

  • Downloading information of different report elements in CSV format:
    • Report general information
    • Model Details
    • Tables Details
    • Calculated Tables
    • Report Level Measures (Connect Live)
    • Row Level Security (if exists)
  • Applying best practices to PBIT files and make them available to download
  • Supporting “Display Folder”

Downloading Report Elements Information

This feature was the most wanted feature our users asked for. We heard your voice. From December 2018, you can download all information that appear in data grid format across the Power BI Documenter in CSV format. Currently you can download the information from the following sections:

Report General Information

When you login to Power BI Documenter you land on “Report” tab by default. On the “Report” tab you see all general information about related to the uploaded Power BI report.

This tab includes statistical information on top and more detailed information in data grid format at the bottom when you scroll down. From now on you can download data grid contents in CSV format. This is very useful when you want to include those information in you offline documentation.

Note: The filters affect the data grid information only and will not affect the CSV contents.

Here is how the downloaded file looks like:

Model

When you click on “Model” tab, you can see different views based on the “Connection Mode” of your Power BI file. If the Connection Mode is “Data Import” then you’ll see the following sections.

Model Diagram

Graphically represents your model relationships and usage in visuals. This part can NOT be exported at this stage.

Model Details

Provides detailed information about your model including Columns, Measures and their attributes like if they are hidden or used in visuals. When you expand this section you’ll see a “DOWNLOAD AS CSV FILE” button within this section. By clicking on that button you can download the contents of the “Model Details” section in CSV format.

Note: The filters affect the data grid information only and will not affect the CSV contents.

Table Details

Provides more detailed information about the Tables and their attributes like is table hidden or if it is calculated table. Click on the “DOWNLOAD AS CSV FILE” button to download the contents of the “Table Details” section in CSV format.

Calculated Tables

Provides calculated tables with their corresponding DAX expressions. Click on the “DOWNLOAD AS CSV FILE” button to download the contents of the “Calculated Tables” section in CSV format.

Report Level Measures (Connect Live)

When you Connect Live to an instance of SQL Server Tabular Model, you have the ability to create report level measures. This is an awesome feature. The problem is that when you connect to an instance of Tabular model from Power BI Desktop, when you create new Report Level measures, those measures will get lost between many other measures that already defined in the Tabular model. Currently in Power BI Desktop the only way that you can find Report Level measures, is to click on the measure, if the formula bar appears then you can see the DAX expressions used to create the measure. With Power BI Documenter, you can simply upload your PBIT file to Power BI Documenter, then click “Model” tab, then from there you can see and download all DAX formula used to create the Report Level measures.

Note: The filters affect the data grid information only and will not affect the CSV contents.

Row Level Security (if exists)

If there is Row Level Security (RLS) setup in your Power BI file, it is good to include it in your documentation. To download the RLS information click “Security” tab then click the “DOWNLOAD AS CSV FILE” button to download the contents of the “Row Level Security (RLS)” section as CSV file.

Applying best practices to PBIT files and make them available to download

This feature was in our wish list for a while. We are very excited to announce general availability of this feature. You can now apply two best practices to your model and download the file accordingly. The two best practices are:

  • Hiding fields not being used in visuals (fields can be columns or measures)
  • Hiding tables not being used in visuals

In lots of cases Power BI developers just fully import all tables at the first place to have everything available in their reports. Then they use some columns in visuals and leave all unused columns and tables visible. Or in some cases you may define a lot of measures while not all of them are used in the visuals. Despite the fact that this is not best practice, in real world, lots of developers do that. It is not like they don’t know about the best practice. In majority of cases we see the developers left the model as is when the project budget is tight and it is really time-consuming to find out which columns or measures are not used in visuals without any tools like Power BI Documenter. The issue doesn’t stop there. After you find out the unused objects, now you have to go and hide all the unused ones which is laborious.

We recognised this issue so we added the best practice section to the August 2018 release of Power BI Documenter. In the December 2018 release, we apply the above best practices to your Power BI Model and make the improved PBIT file available for download. So from now on, you can simply upload your PBIT file, then click “Practices” tab and download the file with best practices applied to it. This is really fascinating feature that can save a lot of development time and make your model more professional.

As you may guessed, this feature is NOT available when you Connect Live to an instance of SQL Server Analysis Services (SSAS).

Here is how your Power BI Model looks before and after applying best practices:

Supporting “Display Folder”

Display folders is a new feature added to the November 2018 release of Power BI Desktop. despite the fact that it is still under preview, we thought it would be great to add that feature to Power BI Documenter. To see the display folders, click “Model” tab then expand “Model Details” section. We added a new column to the data grid names “Display Folder”.

And yes, it is included when you download the CSV format.

In future releases we will add more cool stuff to Power BI Documenter like more best practices to be applied, supporting XMLA to connect Power BI Documenter to Power BI Service and more. Stay tuned.

Power BI Documenter October 2018 Release

10 October 2018 in Announcements

 We’re excited to announce that Power BI Documenter V2.75 (October 2018) has been released for public use. The new release of Power BI Documenter provides lots of new information about your Power BI reports along with one more best practice. In this release we fixed some bugs and added bunch of new features as follows.

Fixed bugs in the new release?

We have noticed a minor bug in “Model Details” data grid under “Model” tab which the “Field” column resized vertically and made it pretty hard to read the text.

We fixed the issue so the “Filed” text will not resize in a way that makes the text unreadable.

We also notified with an issue in the sorting files in the “Files” page. In this release we fixed that issue and from now on your files will be in descending order based on uploaded date.

What is new in October 2018 release?

Power BI Documenter 2.75 comes with a bunch of amazing new features that can help you with your Power BI development as well as documenting your Power BI reports.

  • Supporting built-in themes
  • Detecting unused custom visuals and providing relevant Best Practice
  • Detecting Mobile Friendly reports and visuals
  • Row Level Security (RLS)
  • Report Level Measures when Connect Live to an instance of SSAS

Supporting Built-in Themes

Built-in Themes made available in Power BI Desktop from August 2018. From now on Power BI Documenter detects if a “Built-in” theme has been used in the Power BI reports.

Detecting Unused Custom Visuals

The ability to use custom visuals is awesome. They can take your reports to the whole another level. They are shiny, informative and more importantly, easy to import to your reports. No scripting is needed, you just need to import any desired custom visual to your Power BI report to be able to use them. But, in reality you may import several custom visuals to see how they work. You may use some, but what about the unused ones? You may simply forget to remove them from your model. The problem with unused custom visuals is that they still consume some space in your Power BI report which make your PBIX and PBIT files larger. This release of Power BI Documenter can detect unused custom visuals so you will immediately identify unused ones in your report which perhaps you’d like to remove them as soon as you can. To see which custom visuals are not used in your report, after uploading your PBIT file to Power BI Documenter, click on “Custom Visuals” tab.

Best Practice on Unused Custom Visuals

We added a new best practice about unused custom visuals. If you have at least one unused custom visual you will see the following message under “Practices” tab in “Unused Custom Visuals” dropdown:

Otherwise you see the following green tick:

Detecting Mobile Friendly Reports and Visuals

One of the features available in Power BI that is loved by the end users and customers is “Mobile Friendly” reports. You can easily make wonderful reports that can be easily used on virtually any mobile devices. But, when it comes to Power BI documentation and handover, it is really hard to go through every single report page, switch to “Phone Layout” and see which visuals are used in mobile friendly mode. Using Power BI Documenter you save heaps of time on identifying mobile friendly reports and visuals. All you need to do is to upload your PBIT file to Power BI Documenter then under “Report” page you’ll see  icon if a Phone Layout is available for the report pages and if visuals are used in the Phone Layout.

Row Level Security (RLS)

The October 2018 release of Power BI Documenter supports “Row Level Security (RLS)”. So from now on you’ll get your RLS settings documented after uploading your PBIT file to Power BI Documenter. Then click on a new “Roles” tab added to the Documenter. You can simply expand the dropdown to see the expressions used in the RLS.

Report Level Measures when Connect Live to an instance of SSAS

One of the coolest features of Power BI Desktop is the ability of creating Report Level Measures when connecting live to an instance of SSAS Tabular. This features opens the doors to SSAS Tabular development team to work more closely with Power BI developers in an enterprise scale project. The way it works out is that Power BI developers can create new measures in their Power BI reports when needed. So they don’t need to wait for the SSAS Tabular developers to create the measures and deploy the solution to make the measures available for Power BI developers. As a matter of fact, after the Power BI developers create the Report Level Measures in Power BI, they can simply handover the DAX expressions to SSAS Developers to use those expressions to create the measures in Tabular model. Currently, in Power BI Desktop, there is no easy way to identify the Report Level Measures. It can get a serious problem when you open a Power BI Desktop that someone else developed and you need to identify Report Level Measures. The only way in Power BI Desktop is to click on every single measure in the “Fields” pane and see if any expressions show up in the expression box. Imagine if you have a Power BI report connected to a Tabular model with hundreds of measures and you need to find out which measure is actually a Report Level Measure; that can be a real nightmare.

We at DataVizioner identified this time-consuming process and we are excited to make this feature available in October 2018 release of Power BI Documenter. So from now on, you can simply upload your PBIT file to Power BI Documenter with a simple click, then go to “Model” tab and you can see full information about the “Report Level Measures” and their DAX expressions. We didn’t stop there, in the “Model” page we give you full information about the measure usage in Report Pages and Visuals.