PowerBI Robots 2.3.4

PowerBI Robots 2.3.4: what’s new?

Posted by

PowerBI Robots 2.3.4, the most recent version of our popular Power BI report automation tool, is now available for download and comes packed with a couple of features designed to save users even more time. If you haven’t upgraded to version 2.3.4 yet, click here to download the latest desktop agent or log in to your account on the web agent and click the banner.

PowerBI Robots 2.3.4 introduces:

  • The ability to export data from report visuals to Excel;
  • The new Recipient Email and Recipient Name tokens, along with the flexibility to use them in filters;

Keep reading to learn how to use both features.

Export data from Power BI report visuals to Excel

PowerBI Robots users have been able to send their reports and dashboards as images or PDF files since it launched back in March 2018. Over the following months, our team introduced many variations of these formats, and now Excel joins them, but with a caveat: you must select particular visuals from a report to export their data, a limitation caused by Power BI’s API.

To export data from a Power BI report visual to Excel, make sure Email, File System or SharePoint are selected as the sending method (PowerBI Robots Cloud only works with images) when you create or edit a playlist. Next, click on the Output Format dropdown arrow and select either:

  • Single ExcelPowerBI Robots will output a single Excel file with a sheet for each of your selected visuals;
  • Multiple ExcelsPowerBI Robots will output an Excel file for each of your selected visuals;

PowerBI Robots 2.3.3 -1

After filling all mandatory fields in the General tab, proceed to the Visuals tab in PowerBI Robots and click the Add Power BI Visual button. As mentioned, make sure you select individual visuals instead of reports or dashboards, otherwise, you won’t be able to export any data to Excel.

PowerBI Robots 2.3.3 -2

Navigate to the Filters tab, click “Update” to finish your playlist and you’re done.

Using the new Recipient Email and Recipient Name tokens

We don’t usually cover tokens as their use is very straightforward, but the new Recipient Email and Recipient Name tokens are so elastic that we must talk about them. As you’re probably familiar, tokens in PowerBI Robots serve as placeholders for all sorts of information, allowing you to add some personalization to what an otherwise impersonal mass email delivery system.

You can use the Recipient Name and Recipient Email tokens in email subjects and messages, but filters are where they shine. Up until now, users who had to send filtered data from one report to multiple recipients used the individual filters method. This method removes the need to set up a playlist for each user but can also be time-consuming when you’re dealing with dozens or hundreds of recipients. With the addition of the Recipient Name and Recipient Email tokens, users can now apply individual filters to general reports in one go.

We’re going to use a real case scenario to walk you through this new function.

In this case, we are a retail chain with several District Managers whose data is gathered in a central Power BI report.

PowerBI Robots 2.3.3 -3

We want to share performance with 5 our managers, but don’t want them peering into each other’s numbers.

PowerBI Robots 2.3.3 -3

Instead of filtering data for each of them in the Filters tab, we are going to select one of them and replace him with a Recipient Name token. Select your report from the list, click the Edit Filters button and pick one of the managers from the Name list. In our example, we are picking Alexandria Lindseys. Hit save afterward.

PowerBI Robots 2.3.3 -5

Then, locate that name in the Page Filter field and delete it. Be careful not to delete the quotation marks.

PowerBI Robots 2.3.3 -6

Open the Tokens menu and click Recipient Name. This will copy the token to your clipboard.

PowerBI Robots 2.3.3 -7

Return to the Page filter area and paste the token where you previously deleted your manager’s name.

PowerBI Robots 2.3.3 -8

It should look something like this:

PowerBI Robots 2.3.3 -9

Hit “Update” to finish editing your playlist. PowerBI Robots will now check the names of your recipients and match them to the names in your report, making sure that each of them only sees data filtered by their corresponding value.

If you still have any question, are running into some issues after installing PowerBI Robots version 2.3.4 or have some suggestions for future releases, please check the product’s 101 or email us at support@devscope.net. Your feedback is greatly appreciated.

PowerBI Tiles Pro banner

4 comments

  1. The token for email name is helpful, but it would be great to have other options to pass in, such as a key value or customer company name. If there were additional attributes of data you can add with a custom name per recipient and those work as tokens. For example, if your filter had a CompanyName field, you could add a CompanyName value to your recipient list next to their name and email.

  2. Why restrict the filtering to Recipient Name and Recipient Email? What’s so hard about integrating Recipient Path, for instance?
    I also like the idea of creating recipients out of column values and using those in filters.

    1. Hi, Alexander.
      Thank you for the suggestion. Can you give us an example of Recipient Path you would like to see in PowerBI Robots?

Leave a Reply