• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Tag Archives: Desktop

You must know about this shortcut key in #PowerBI Desktop

December 7, 2020   Self-Service BI

Working with the field list on a large model in Power BI Desktop can quickly make you end up with a lot of expanded tables and you collapsing them one by one.

 You must know about this shortcut key in #PowerBI Desktop

Don’t do that

Even though that is good if you want to improve your chances of beating your kids in Fortnite – it probably won’t – so instead do one of the following

If you want to use your mouse

Click the show/hide pane in the header of the Fields panel

 You must know about this shortcut key in #PowerBI Desktop

This will collapse all expanded tables in the field list at once – plus if you have used the search field – it will clear that as well.

But you want to do it using the keyboard use

ALT + SHIFT + 1

This will collapse all the expanded tables as well.

Here is a link to the documentation about short cut keys in Power BI desktop – run through them – there might be some that can save you a click or two

Keyboard shortcuts in Power BI Desktop – Power BI | Microsoft Docs

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query

Read More

Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

November 28, 2020   Self-Service BI

On my computer I have 2 versions of Power BI Desktop installed – one from the Microsoft Store which is updated automatically and the downloaded version from downloads – and typically I have last month edition as my downloaded version.

But in my taskbar its impossible to tell the difference between the two.

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

Well we can solve that by changing the icon for the downloaded version – its not possible for the store version.

If you right click the icon in the taskbar and then right click the Power BI Desktop

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

You can select the properties for this App.

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

Now click the Change Icon

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

This will show you the current icon and now you can change this by clicking Browse – in my case I will select the icon for the PBIDocument

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

And click open – then icon will now be set to this

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

And when clicking OK

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

We will see the icon has changed for the Shortcut.

Notice that it will change immediately

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

But after a restart it will appear

 Spot the difference between Power BI Desktop and Power BI Desktop (Store Version) #PowerBI

Hope this can make your choice of Power BI Desktop versions easier for you as well.

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query

Read More

Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

August 22, 2020   Self-Service BI

I recently created an external tool to PowerBI desktop that connects your Power BI desktop model to Excel (https://eriksvensen.wordpress.com/2020/07/27/powerbi-external-tool-to-connect-excel-to-the-current-pbix-file/) and then I thought – could we also have a need for an external tool that could open the desktop model in Tableau desktop.

So, I downloaded a trial version of the Tableau Desktop to see what is possible.

And sure, enough Tableau can connect to Microsoft Analysis Services and therefor also the localhost port that Power BI Desktop uses.

082020 1030 connectyour1 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

We can also save a data source as a local data source file in Tableau

082020 1030 connectyour2 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

Which gives us a file with a tds extension (Tableau Data Source)

082020 1030 connectyour3 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

When opening the file in Notepad we can see the connection string and some extra data about metadata-records.

082020 1030 connectyour4 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

It turns out that the tds file does not need all the meta data record information – so I cleaned the tds file to contain

082020 1030 connectyour5 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

Opening this file from the explorer will open a new Tableau Desktop file with the connection to the specified model/database/server.

The external tool

Knowing this I could create an external tool the same way as my Excel connector.

First create a PowerShell

OBS – in order to run a powershell script on your pc you need to have to set the execution policy – https://go.microsoft.com/fwlink/?linkid=135170

The PowerShell script

Function ET-TableauDesktopODCConnection
{  

	[CmdletBinding()]
    param
    (
        [Parameter(Mandatory = $  false)]        
		[string]
        $  port,
        [Parameter(Mandatory = $  false)]        
		[string]
        $  database,
        [Parameter(Mandatory = $  false)]        
		[string]
        $  path	
    )
    
        $  tdsXml = "<?xml version='1.0' encoding='utf-8' ?>
<datasource formatted-name='LocalPowerBIDesktopFile' inline='true' source-platform='win' version='18.1' xmlns:user='http://www.tableausoftware.com/xml/user'>
  <document-format-change-manifest>
    <_.fcp.SchemaViewerObjectModel.true...SchemaViewerObjectModel />
  </document-format-change-manifest>
  <connection authentication='sspi' class='msolap' convert-to-extract-prompted='no' dbname='$  database' filename='' server='$  port' tablename='Model'>
</connection>
</datasource>"   
                
        #the location of the odc file to be opened
        $  tdsFile = "$  path\tableauconnector.tds"

        $  tdsXml | Out-File $  tdsFile -Force	

        Invoke-Item $  tdsFile

}

ET-TableauDesktopODCConnection -port $  args[0] -database $  args[1] -path "C:\temp"

The script simply creates a tableauconnectort.tds file and stores it in C:\temp – and the xml content in the file is dynamically referenced as arg(0) and arg(1) when the external tool is called from Power BI Desktop.

Save the script in C:\temp and call it ConnectToTableau.ps1.

The OpenInTableau.pbitool.json file

Next step was to create a pbitool.json file and store it in C:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools

{
  "version": "1.0",
  "name": "Open In Tableau",
  "description": "Open connection to desktop model in Tableau ",
  "path": "C:/Windows/System32/WindowsPowerShell/v1.0/powershell.exe",
  "arguments": "C:/temp/ConnectToTableau.ps1 \"%server%\" \"%database%\"",
  "iconData": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJAAAACQCAYAAADnRuK4AAAABmJLR0QA/wD/AP+gvaeTAAADRklEQVR4nO3dv27TUBiH4WPEitSRS+iCurO0GzdRiS5sXRhAXZhYEAxd2LoUiZtgaxb2iqWXwFiJCzgsqPRPrMb5Jc1x/TxbqgSi5O2xE3+uSwGAUeo2/QRac3R8cla6bvfqB7XOPr19s7e5Z9S2J5t+AoybgIgIiIiAiAiIiICICIiIgIgIiIiAiEziUMbR8cnZovetXbfTlbJ1dbuUy67W80UfP7XDHk83/QQexPVjW/fd9e7trSGPnxqbMCICItLEJqyeljrv593BivbRap0tfNdwH2hVDj58mfuanH5819R+axMBrduQHdvb80BdredT2zEewiaMiICICIiIgIgIiIiAiAiIiICICIiIgIhM4lDGEA5bDGMFIiIgIgIiIiAiAiISTbf1TRK2ZmWTjQvomyRszaomG61ARAREREBEBEREQESaOMdo7eeFjdBYzguzAhEREBHjHP/8fv/i3i8An3/+1dTmowVWICICIiIgIgIiIiAiAiIiICICIiIgIgIiIiAiSx8Lc3Xjcdk/nJ2VWv+/X103+/51dy/9d61ARAREpIlxjilPHvZpbfKwjxWIiICICIiIgIgIiEgTn8KGWmQAfiz/79gH9a1ARG7UP5arG29qBVqHZAXaP5ydDbj7Tqn16v0qXXdZSln4/eo77HFzE+bqxuNy/djW8MdulVLi98smjIiAiNzchI3w6saT1nULv18l3AfqfQrLPnCT80B2ooczD0STRvlF4jp+a/11juVYgYgIiIiAiAiIiICINPEp7Of29txPQC8vLib7qefZq29zX5M/P1439ZpYgYgIiMjSmzCnMY/LKg5bzGMFIiIgIgIiIiAiAiIiICICIiIgIgIiIiAiAiLSxDhHCwzML8cKRERARKJlu2+SsDUPOdnYN0nYmlVNNlqBiAiIiICICIiIgIg08eWZ88Lucl4YkyAgIgIiIiAiAiJinOOWdf0108fKCkREQEQERERARAREREBEBEREQEQERERARCZxKGPw1Y1v3R7y+Kkd9mgioLVPHjZwdeOhWps87GMTRkRARJrYhK1dA1c3fqxGsZ19SOaBhrEJIyIgIgIiIiAiAiIiICICIiIgIgIiIiAAAAAYjb8VJdQbiRXyOAAAAABJRU5ErkJggg=="
}

Test it

Now restart your Power BI desktop and the external tool should be visible in the ribbon

082020 1030 connectyour6 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

Then open a pbix file with a model and hit the button.

A PowerShell screen will shortly be visible and then Tableau opens the tds file and now we have a new tableau book with a connection to active power bi desktop datamodel.

082020 1030 connectyour7 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

And we can start to do visualizations that are not yet supported in Power BI –

082020 1030 connectyour8 Connect your #PowerBI desktop model to #Tableau Desktop via External Tools in PowerBI

How can you try it

You can download the files needed from my github repository – link

Feedback

Let me know what you think and if possible share some of the viz that you make.

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query

Read More

#PowerBI – Copy a measure in the desktop – Why it doesn’t always work – mystery solved

January 22, 2020   Self-Service BI

Well – creating measures in the Power BI desktop is usually doing a lot of copying and pasting of measures.

And unfortunately, we haven’t yet gotten a Copy measure in the shortcut menu when we right click a measure

 #PowerBI – Copy a measure in the desktop – Why it doesn’t always work – mystery solved

Here is an idea you can vote for if you would find it useful as well – https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13219620-duplicate-measure-and-format-copy

So we end up copying the formula from text in the formula bar

 #PowerBI – Copy a measure in the desktop – Why it doesn’t always work – mystery solved

And click new measure and Paste it into the formula bar

 #PowerBI – Copy a measure in the desktop – Why it doesn’t always work – mystery solved

 

But 8 of 10 times nothing is pasted (at least when I select) – WHY ???

 

And now I finally took me the time to find out why –

 #PowerBI – Copy a measure in the desktop – Why it doesn’t always work – mystery solved

Notice the colour of the selection in the picture above compare to this

 #PowerBI – Copy a measure in the desktop – Why it doesn’t always work – mystery solved

If the colour is darker blue you can copy and paste but if its lighter blue – you can’t – and this is properly because you use your mouse to select the formula and if you release the mouse outside of the formula bar area – the selection will be light blue and when you then press CTRL + C to copy the formula text isn’t copied to the clipboard.

Solution

So, either make sure you don’t move your pointer outside the area or use CTRL + A to select all and then press CTRL + C to copy the formula.

 

Hope this can save you a couple of clicks and please vote for the idea – https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13219620-duplicate-measure-and-format-copy – this also includes the idea that the formatting of the value should be included.

 

Power On!

 

 

 

 

 

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query

Read More

Happy New Year from Power BI Desktop!

January 2, 2020   Self-Service BI
social default image Happy New Year from Power BI Desktop!

Happy New Year!

In honor of the new year, our team put together this fun video where we reveal what makes Power BI what it is today! Enjoy!

This month we will have a Power BI Report Server update only, but starting February, Power BI Desktop will continue our monthly ship cadence.

Looking forward to another great year!

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Read More

Power BI Desktop November 2019 Feature Summary

November 16, 2019   Self-Service BI

The November update has major updates in several areas of Power BI Desktop. There’s a new, modern ribbon that aligns Power BI Desktop with Office and adds more functionality. We’re also adding a new visual, the decomposition tree, which is one of the most requested ideas on ideas.powerbi.com. AI functions integrated into Power Query allows you to take your data transformations to the next level, and of course we have incremental improvements across the entire product.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop November 2019 Feature Summary

Here’s the complete list of November updates:

Other

Reporting

Analytics

Visualizations

Data connectivity

Data Preparation

Template apps

Modern ribbon (preview)

Continuing our journey to modernize the editing experience for all our users, this month we are previewing a new ribbon. If this ribbon looks familiar to you, it is because we are now using the same ribbon that you see when using Office 365.

111119 0633 PowerBIDesk1 Power BI Desktop November 2019 Feature Summary

This new ribbon has several benefits compared to the previous ribbon:

  • Improved look and feel and organization
  • A themes gallery, where you can more easily see what colors will be applied

    111119 0633 PowerBIDesk2 Power BI Desktop November 2019 Feature Summary

  • Dynamic ribbon content based on your view, so you no longer have many disabled buttons in the data and modeling view

    111119 0633 PowerBIDesk3 Power BI Desktop November 2019 Feature Summary

  • A single line ribbon when the ribbon is collapsed, which allows you to save space while working

    111119 0633 PowerBIDesk4 Power BI Desktop November 2019 Feature Summary

  • The ribbon won’t occasionally freeze, for those who had that issue with the previous ribbon

There are also a lot of benefits to come with this update as well. The new ribbon allows us to, in future updates:

Hopefully, it’s obvious from the list of future additions we want to do, but this is just the first of more updates that will come for the ribbon. Make sure to let us know what else you’d like to see added or changed in our ribbon!

We also have a dedicated blog post just on our ribbon updates, so make sure to check that out.

Watch the following video to learn more about the new ribbon:

Decomposition tree visual (preview)

We are very excited to announce a preview of one of the most and longest requested features for Power BI, a decomposition tree visual. A decomposition tree can use to perform root-cause analysis by viewing how individual categories in a group contribute to the whole. The visual lets you decompose, or break down, a group to see its individual categories and how they can be ranked according to a selected measure, such as by sales amount.

111119 0633 PowerBIDesk5 Power BI Desktop November 2019 Feature Summary

Once you turn on the visual through the preview tab of the Options dialog, you’ll see the new visual option in the visualization pane.

111119 0633 PowerBIDesk6 Power BI Desktop November 2019 Feature Summary

Once you add the visual to your page, you’ll see two buckets in the field well. The first, Analyze, is where you’ll put the numeric field you want to break down, in my case Sales Amount. The second bucket, Explain by, is where you’ll put all the possible fields you’d want to break your numeric field down by.

111119 0633 PowerBIDesk7 Power BI Desktop November 2019 Feature Summary

One of the interesting difference in the decomposition tree, compared to other visuals, is that you get to pick dynamically which of the fields in the explain by field well you want to look at and in what order. This means that the initial view you’ll have is just the numeric value with a small “+” next to it.

111119 0633 PowerBIDesk8 Power BI Desktop November 2019 Feature Summary

Clicking on this plus will allow you to either pick a specific field from the provided options to break down by or let the visual decide which field to use, depending on if you’re looking for the highest or lowest value.

111119 0633 PowerBIDesk9 Power BI Desktop November 2019 Feature Summary

As you expand on different fields, you’ll see a path forming in your tree. If the tree expands beyond the dimensions of the visual, you can pan and zoom with your mouse to get a better view.

111119 0633 PowerBIDesk10 Power BI Desktop November 2019 Feature Summary

As you go further down the tree, you can look at the headers and the darkened lines to get a reminder of what part of the tree you’re exploring.

111119 0633 PowerBIDesk11 Power BI Desktop November 2019 Feature Summary

111119 0633 PowerBIDesk12 Power BI Desktop November 2019 Feature Summary

If you pick either high or low values to expand on, you’ll also see an lightbulb next to the header to remind you that Power BI is picking the field for you dynamically and it’ll update and change as your data refreshes. The connecting line is also dotted, as another visual cue.

111119 0633 PowerBIDesk13 Power BI Desktop November 2019 Feature Summary

Like our other built-in visuals, you get all the good features you’d expect, such as support for:

  • Cross-highlighting
  • Picking up theme colors
  • Formatting options

    111119 0633 PowerBIDesk14 Power BI Desktop November 2019 Feature Summary

  • Bookmarking

When you save your report, the visual will remember what configuration it was in and reopen to that format, but your consumers will be able to explore and configure the visual as much as they want to find new insights.

If there are specific levels you don’t want your users to change, you can lock them using the lock icon near the header (you won’t have this option for AI driven levels).

111119 0633 PowerBIDesk15 Power BI Desktop November 2019 Feature Summary

Make sure to try out this visual while it is in preview and let us know what else you’d like to see added!

Watch the following video to learn more about the decomposition tree:

Conditionally format button formatting

This month’s conditional formatting update for formatting are all button related. You can now dynamically set formatting for the following properties:

  • Button text font color
  • Button text
  • Icon line color
  • Outline color
  • Fill Color
  • Button tooltip (under the action card)

As a remainder, you can tell a property can be conditionally format-able by looking for the three dots on hover.

111119 0633 PowerBIDesk16 Power BI Desktop November 2019 Feature Summary

And once a property has been dynamically set, it will be replaced with an fx button.

111119 0633 PowerBIDesk17 Power BI Desktop November 2019 Feature Summary

Watch the following video to learn more about dynamic button formatting:

ArcGIS Maps for Power BI update

The ArcGIS Maps for Power BI visual has several updates this month. The visual now has support for connecting to ArcGIS Enterprise servers using built-in authentication. You can also now geocode up to 3500 points as a free user and 10,000 as a ArcGIS subscriber. Lastly, if you’re an ArcGIS subscriber you now get full Esri Technical Support for ArcGIS Maps for Power BI.

New xViz visuals

There are two new visuals in the xViz suite this month! As a quick reminder, the xViz suite is an all in one visual suite. There are currently 9 visuals in the package, all with free and pro features. If you decide to license the pro features, you get access to the advanced capabilities for all the visuals for one price.

Advanced Gauge

The Advanced Gauge visual allows you to easily compare an actual value, such as your key business indicators, against a target value. There are a lot of customization and configuration options available for this visual. Your gauge can either be a full or semi circle, with the added ability of showing two different metrics in the same gauge. Some other configurations include:

  • Conditional formatting options for the gauge fill color
  • Set a fill and/or needle indicator for the current value
  • Control the colors for the target indicator
  • Set a min/max value
  • Axis and number formatting, including tick control

111119 0633 PowerBIDesk18 Power BI Desktop November 2019 Feature Summary

Check it out on AppSource.

Watch the following video to learn more about the advanced gauge:

Hierarchical Filter

The Hierarchical Filter visual is a slicer visual that supports hierarchies, advanced formatting, search, and even displacing a metric of choice. Each node of the slicer allows you to expand and collapse it for optimal navigation and allows you to easily single and multi-select categories to filter by.

Some of the advanced formatting options for this visual include:

  • Conditional formatting support for both the categories of the slice and the optional metric
  • Search support with two different search types
  • Setting the default expansion level
  • Full text and background formatting, including unique formatting for hover and selected value
  • Advanced number formatting

111119 0633 PowerBIDesk19 Power BI Desktop November 2019 Feature Summary

Try at this visual from AppSource.

Watch the following video to learn more about the hierarchical filter:

ZoomCharts Drill-Down Waterfall Visual

The ZoomCharts Drill Down Waterfall visual is a new addition to the family of ZoomCharts custom visuals and
is equipped
with all ZoomCharts signature features – interactive drill down, smooth animations and rich customization options. The visuals are optimized to work on both desktop and mobile devices providing intuitive user experience.

The ZoomCharts Drill Down Waterfall visual introduces more freedom and flexibility when it comes to visualizing increases and decreases, and totals. Some of the key features of this visual include:

  • Subtotal display and calculation – add and display subtotals straight from the dataset or calculate them automatically;
  • Column sequence – set the display order for columns (change values)
  • Display of the total – turn on or off the total column; have it calculated dynamically or make it data driven
  • Advanced formatting options – customize increases, decreases and totals separately (colors, outlines, column widths, connectors, value labels and more)
  • Touch-driven slicer – filter the report page by using the visual itself (no need for external slicers)
  • Touch-driven drill down – touch or click any column to drill down into it; long-press it to select the column

Some common use cases for the Drill Down Waterfall include total profit and loss decomposition in accounting and finance, monitoring stock movement in inventory management, understanding campaign contributions to lead volume in sales and marketing, and viewing changes in staff numbers in human resources.

111119 0633 PowerBIDesk20 Power BI Desktop November 2019 Feature Summary

Download from AppSource.

Watch the following video to learn more about ZoomCharts Drill-Down Waterfall visual:

Financial Reporting Matrix by Profitbase

The Financial Reporting Matrix by Profitbase visual is geared towards easily building financial reports. The visual is a matrix with many of the formatting options you’d expect in a financial report. Some of the features of this visual include:

  • Sub and grand total controls
  • Line formatting
  • Sticky column and row headers
  • Conditional formatting

111119 0633 PowerBIDesk21 Power BI Desktop November 2019 Feature Summary

Learn more on AppSource.

Watch the following video to learn more about the financial reporting matrix by Profitbase:

Distribution

The Distribution visual by Inservit allows you to see an indicator for each categories of the field you put into the visual, much like the legend of a visual. You can use these indicators as a way to filter the report. The indicators have a lot of formatting options, including:

  • Ability to show or hide the category and data labels
  • Change the indicator border and share
  • Swap the orientation between horizontal and vertical
  • Conditional formatting for the indicators, and border

111119 0633 PowerBIDesk22 Power BI Desktop November 2019 Feature Summary

Find this visual on AppSource.

Watch the following video to learn more about the distributions visual:

Tree

The Tree visual by CK Corporation allows you to visual your hierarchical data in an easy to use tree structure. All you need to do is give the visual a parent id and child id, and it will automatically figure out the tree structure. If there are multiple levels to the tree, you can expand nodes by hovering over them and clicking the plus icon. You can also use various formatting features, such as:

  • Switching between horizontal and vertical orientation
  • Set the default expansion level
  • Customize the labels
  • Change the node and line styles
  • Set conditional formatting for the nodes

111119 0633 PowerBIDesk23 Power BI Desktop November 2019 Feature Summary

Download it from AppSource.

Watch the following video to learn more about the tree visual:

LinkedIn Sales Navigator connector (beta)

LinkedIn Sales Navigator lets you access the power of LinkedIn’s 630M+ member network to help sales professionals find and build relationships with prospects and customers. If you’re using this feature, you can now pull your data into Power BI using our new connector. You need to have a LinkedIn Sales Navigator Enterprise plan, and be either an Admin or Reporting User on the Sales Navigator Contract to connect to this data.

111119 0633 PowerBIDesk24 Power BI Desktop November 2019 Feature Summary

Edit SAP variables experience now generally available

Back in August, we released a preview of our Edit SAP variables experience, to allow report consumers to edit SAP variables in the Power BI service with their DirectQuery reports. This month, we’re excited to announce that this experience is now generally available and also supported in Shared workspaces. Read our documentation to see how to set this experience up.

111119 0633 PowerBIDesk25 Power BI Desktop November 2019 Feature Summary

Vena connector

Vena’s finance process management software accelerates and improves budgeting, forecasting, planning, financial close management and consolidations, and more, by connecting people and enterprise data, resulting in better planning, better decisions making, and an elevated role for finance. The Vena Power BI connector easily connects Vena data to Power BI. Enable faster analysis, greater insights, and better decisions by enabling access to self-service enterprise data analytics.

SiteImprove connector

SiteImprove offers a comprehensive cloud-based Digital Presence Optimization (DPO) software. Create higher quality content, drive better traffic, measure digital performance, and work towards regulatory compliance – all from one place. The connector gives access to SiteImprove’s digital insights data to monitor your websites performance for accessibility, SEO, analytics, quality assurance, and much more to help you and your team to create higher quality content, drive better traffic, measure digital performance, and work towards regulatory compliance. Find out more at https://siteimprove.com/en/core-platform/integrations/connectors/power-bi/.

Product Insights connector

Product Insights is a new Dynamics 365 product which allows you to collect signals from your products and services, and gain valuable insight into customer usage, in real-time. The connector accesses aggregated signal data (metrics) from Product Insights. Find out more at https://pi.dynamics.com/.

Web By Example connector – support for extracting links

We’re glad to announce a significant enhancement to the Web By Example connector, allowing you to extract links (src/href attributes) as part of the Web By Example experience.

In the example below, we’re leveraging this new capability in order to extract information about Power Query Books (including Author, Title and URL) from the Power Query resources page: https://powerquery.microsoft.com/en-us/resources/

111119 0633 PowerBIDesk27 Power BI Desktop November 2019 Feature Summary

Watch the following video to learn more about the updates to the Web by Example connector:

AI functions in Power Query (Preview)

After introducing AI functions in the Power BI service earlier this year, we’re now releasing these features in Desktop as well. You can extract insights from your text and image data with models for text analytics and vision, and access all your Azure Machine Learning models directly in Power BI Desktop. You’ll notice new buttons show up in the Power Query editor once you have the ‘AI functions’ option enabled in the preview settings.

 Power BI Desktop November 2019 Feature Summary

Text analytics can help you detect the language of a text column or field, score its sentiment, or extract key phrases. Detect topics in images with the image tagging function, or run new data through your own Azure ML models. The results of each function are added as a new column to the query.

111119 0633 PowerBIDesk26 Power BI Desktop November 2019 Feature Summary

 For functions that return multiple values – currently this is true for Key Phrase Extraction and Image Tagging – the results are returned both as a comma separated column and as new rows for each separate key phrase or tag.

Text analytics and vision models are Premium only features. In the setup window you can choose which capacity to use while editing the report. When you publish the report to a Premium workspace, we will use the capacity related to that workspace for any data refresh. Text analytics and vision functions can’t be refreshed in non-Premium workspaces.

LinkedIn Sales Navigator for Sales Operations

The LinkedIn Sales Navigator for Sales Operations template app allows sales operations personnel to see aggregated information about how effectively a sales team uses Sales Navigator. It enables sales operations personnel to identify and analyze things like:

  • Who is using LinkedIn Sales Navigator
  • How many LinkedIn profiles match search criteria
  • The Social Selling Index across all users

To use this template app, you must:

  • Have a LinkedIn Sales Navigator Enterprise plan
  • Be an Admin or a Reporting User on the Sales Navigator Contract (Note: A reporting license on the Sales Navigator contract does not take up a seat on that contract)
  • Be a Power BI user

The LinkedIn Sales Navigator for Sales Operations template app is available for download from AppSource.

Watch the following video to learn more about the LinkedIn Sales Navigator template app:

That’s all for this month! We hope that you enjoy these updates for the month. Please continue sending us your feedback and don’t forget to vote for other features that you’d like to see in the Power BI Desktop. For any preview features, you can always give us your feedback in our active community. You can also download the .pbix file I used, and if you’re looking for a similar design for your reports, I was using the Microsoft layout from PowerBI.Tips.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop November 2019 Feature Summary

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Read More

Updated Ribbon Experience for Power BI Desktop

November 13, 2019   Self-Service BI

The ribbon in Power BI Desktop has an updated and modern experience. When you turn on the “Updated ribbon” preview feature, you will see a ribbon that looks more like the ribbon in Office products. In the updated ribbon, you have access to all the existing features that you know and love, and over time, more features will be added to the ribbon.

If you have feedback about the updated ribbon, we’d love to hear from you!

The Journey

When we started the journey of redesigning the ribbon, some of the goals we kept in mind were to:

  • Make the report design experience easier
  • Align with Office and feel familiar
  • Provide a visual refresh and modernize the aesthetic of Power BI’s UI

We looked at your feedback and investigated how report designers are creating reports. With this information, we added in another ribbon tab and reorganized the buttons in each tab into conceptual groupings.

Building an updated ribbon was a joint effort between Power BI and our Office partners. The previous Power BI Desktop ribbon was replaced with the ribbon component from Office.  Thanks to their help, we can provide a modern ribbon experience!

What’s New

To see detailed changes on updates made in the ribbon, see the Where did the actions go? section below.

Insert Tab

Adding buttons, shapes, and textboxes to your report have been moved to a new Insert tab.

110919 0043 UpdatedRibb1 Updated Ribbon Experience for Power BI Desktop

Theme Gallery

The updated ribbon displays themes in a gallery so you can more easily see what colors will be applied to your report.

110919 0043 UpdatedRibb2 Updated Ribbon Experience for Power BI Desktop

You can still see the name of a theme by hovering over a thumbnail.

110919 0043 UpdatedRibb3 Updated Ribbon Experience for Power BI Desktop

Contextual Tabs – Table Tools, Measure Tools, Column Tools

More tabs, also known as contextual tabs, will show up in the ribbon according to what you have selected. For example, in the previous ribbon, if you selected a visual, the contextual tabs “Format” and “Data / Drill” appear. In the new ribbon, you may have noticed that the “Modeling” tab has fewer buttons. Now, if you want to modify the structure, properties, or apply formatting to tables, columns, and measures, these options will appear as contextual tabs when you select a field in the fields list. The tools available to modify your data are now grouped according to the type of field you have selected. This should help reduce clutter and unnecessary options as you are modifying your data.

110919 0043 UpdatedRibb4 Updated Ribbon Experience for Power BI Desktop

110919 0043 UpdatedRibb5 Updated Ribbon Experience for Power BI Desktop

110919 0043 UpdatedRibb6 Updated Ribbon Experience for Power BI Desktop

More Visuals

Previously, you could browse custom visuals in the button “From Marketplace”. Because custom visuals are hosted in AppSource, you can now find them by pressing the “More visuals” dropdown and selecting “From AppSource”.

110919 0043 UpdatedRibb7 Updated Ribbon Experience for Power BI Desktop

Simplified Ribbon

If you press the chevron in the bottom right hand corner of the ribbon, the ribbon will collapse to help you save space while working.

110919 0043 UpdatedRibb8 Updated Ribbon Experience for Power BI Desktop

Friendlier names and detailed tooltips for buttons

We heard your feedback that some terms that appear in the ribbon are ambiguous. We’ve gone through and updated some of the names for buttons to be more friendly. We’ve also updated all tooltips to give a more detailed explanation as to what the feature does.

To see a detailed list of the changes made, see the Where did the actions go? section below.

Here are some prominent changes to look out for:

  • “Edit Queries” now appears as “Transform data”

    110919 0043 UpdatedRibb9 Updated Ribbon Experience for Power BI Desktop

  • Adding a custom visual “From Marketplace” is now “From AppSource”

    110919 0043 UpdatedRibb10 Updated Ribbon Experience for Power BI Desktop

    “From AppSource” can be found under the “More visuals” dropdown

    110919 0043 UpdatedRibb11 Updated Ribbon Experience for Power BI Desktop

  • Because “See Data” shows the data in a selected visual in a tabular format, it has been renamed as “Visual table”

    110919 0043 UpdatedRibb12 Updated Ribbon Experience for Power BI Desktop

  • “See Records” has been renamed “Data point table”, which shows the underlying data that has been used to calculate a data point in a tabular format.

    110919 0043 UpdatedRibb13 Updated Ribbon Experience for Power BI Desktop

File Menu

The file menu has a modern look.  If you work with several reports, in the Open section of the modern file menu, you’ll be able to see and pin more reports than you were able to previously.

110919 0043 UpdatedRibb14 Updated Ribbon Experience for Power BI Desktop

What’s Coming

This is the first of many updates that are coming to the ribbon. The new ribbon control allows us to, in future updates:

  • Use more flexible and intuitive controls for features
  • Add the black and dark grey Office themes to Power BI Desktop
  • Improve accessibility to be on par with Office’s ribbon

Please note that the Quick Access Toolbar will be unavailable in the updated ribbon.  We are working a future update to add “Save” to the title bar. Feel free to leave us feedback on this experience.

In the first quarter of 2020, the updated ribbon will transition from being a preview feature to be the default ribbon you see in Power BI Desktop. If the updated ribbon experience is severely impacting your workflow, you will still be able to turn off the updated ribbon in your preview features in the report options dialog. However, when the updated ribbon is the new default, the previous ribbon will be deprecated. If you turn off the updated ribbon, you will not get access to all the newest features in Power BI. Shortly after, you will no longer be able to turn off the updated ribbon. Be sure to leave us feedback at our community forum.

Where did the actions go?

Renamed Features

We received feedback from you guys that some of the names we had for buttons weren’t intuitive or didn’t make sense. Here are the new names for features you may be trying to find:

Formerly known as New Name
Edit Queries Transform data
From Marketplace From AppSource
Switch Theme Turned into a theme gallery
New Group New data group
Edit Groups Edit data groups

Ribbon Buttons in the Updated Ribbon

Note: Group refers to the name of a section in a ribbon tab. For instance, the Paste button is in the Home tab and in the Clipboard group.

110919 0043 UpdatedRibb15 Updated Ribbon Experience for Power BI Desktop

Action Updated Ribbon OFF Updated Ribbon ON
New page Home > Insert group Insert > Pages group
New visual Home > Insert group Insert > Visuals group
Buttons

Text box

Image

Shapes

Home > Insert group Insert > Elements group
From AppSource

From File

Home > Custom visuals group Home > Insert group > More visuals
Switch Theme Home > Themes group View > Themes group
Manage Relationships Home > Relationships group Modeling > Relationships group
Data Formatting group

Data Properties group

Modeling Once you select a table, column, or measure in the Fields List, contextual tabs (Table tools, Column tools, Measure tools) will appear in the ribbon
New data group

Edit data groups

Modeling > Groups group Select a column in the fields list

Column tools > Groups group > Data groups

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Read More

Power BI Desktop October 2019 Feature Summary

October 14, 2019   Self-Service BI

This month’s update is filled with major updates across the whole product. In the data preparation area, we’ve introduced query diagnostics, which allow you to see what queries are being run behind the scenes. On the reporting side, we are taking a huge step forward in terms of real-time reporting, with our new automatic page refresh feature.  This feature lets you trigger refreshes for your DirectQuery-based report at regular intervals.  Q&A has also been completely revamped this month, with a new Q&A visual, tooling, and improved user experiences.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop October 2019 Feature Summary

Here’s the complete list of October updates:

Reporting

Analytics

Visualizations

Data connectivity

Data Preparation

Template Apps

Other

For a summary of the major updates, you can watch the following video:

When monitoring critical events with Power BI, it’s important that the data is reflected in Power BI as soon as the data source gets updated. For example, in the manufacturing industry, it’s critical to know when a machine is malfunctioning. To enable this, we are releasing automatic page refresh, which allows you to set the refresh interval of visuals in your report when using a DirectQuery source. For very fast updating sources, this near real-time experience will allow your consumers to monitor time-critical reports and ensure that they are always viewing the latest.

To use automatic page refresh, make sure you have it turned on in the preview Options dialog.

After that, you’ll see a Page refresh card in the formatting pane for the page when connected to a DirectQuery source. In that card, you’ll set the duration of your refresh.

100319 0140 PowerBIDesk1 Power BI Desktop October 2019 Feature Summary

In Desktop, you can set up this refresh as frequent as once every second, assuming your DQ source can handle that. In the service, the minimum refresh time is 30 minutes for a regular workspace, so once you publish the report, the duration will be overwritten if it’s less than 30 min. If your workspace is part of a premium capacity, your duration can go as low as the minimum set by the capacity admin and will only work if the admin has enabled automatic page refresh in the capacity.

To learn more about the automatic page refresh preview you can read our documentation

Watch the following video to learn more about automatic page refresh:

The new Q&A Visual

This month we are bringing NLG (natural language generation) even more to the forefront of reporting in Power BI with a new Q&A visual. This is a full visual experience that allows you to give the Q&A experience to your end-users. While similar to using a button to trigger Q&A, this visual can improve discoverability for your report consumers, as the experience isn’t hidden behind an extra button click. The new Q&A Visual can interact, cross filter, support bookmarks and be themed just like any other visual. To add the visual to the report, just click on the Q&A icon from the visualization pane.

100319 0140 PowerBIDesk2 Power BI Desktop October 2019 Feature Summary 

This will add the Q&A visual to the report page with an input box for you to type your questions and a few suggestions to get started with.  Clicking any of the suggestions will automatically populate the input box with that question and show you the result.  

100319 0140 PowerBIDesk3 Power BI Desktop October 2019 Feature Summary

Otherwise, if you have your own question to ask, type it out and see Q&A automatically give you the result.  

100319 0140 PowerBIDesk4 Power BI Desktop October 2019 Feature Summary 

As a report author, you also have the ability to use this visual as an authoring tool and convert the Q&A visual into the specific visual you’re seeing if you’d like to stick with that one visual. Just click the icon next to the input box. 

100319 0140 PowerBIDesk5 Power BI Desktop October 2019 Feature Summary 

Near the top of the visual result, you’ll also see an info icon that has the restatement as a tooltip. If you ever want to confirm what the Q&A result is showing you, you can hover over this icon to see the restatement. 

100319 0140 PowerBIDesk6 Power BI Desktop October 2019 Feature Summary 

The state the Q&A visual is in when you save your report is what your report consumers will see as well. So if you have the report with a Q&A in the box, that will be the default view for your end users. You can also use bookmarks to save different Q&A questions for your end users. The Q&A visual will also automatically pick up your applied theme and cross-highlight automatically works between visuals on the report page and the Q&A visual. 

You also have complete formatting control over the question input box through the question field card in the formatting pane.  

100319 0140 PowerBIDesk7 Power BI Desktop October 2019 Feature Summary 

The suggestions’ appearance can also be formatted.  

100319 0140 PowerBIDesk8 Power BI Desktop October 2019 Feature Summary 

If you’re using the Ask a Question button in the ribbon or double-click to trigger the Q&A experience, those entry points will now create Q&A visuals. 

Improved user experience for Q&A

We’ve also updated the user experience for the Q&A question input box. You’ll see blue underlines on terms that we understand from your data model. Red underlines are used for terms that are ambiguous or we don’t understand at all. There is also a new dropdown experience when selecting a specific auto-suggestion as you type that is similar to what you get in web search engines.  

100319 0140 PowerBIDesk9 Power BI Desktop October 2019 Feature Summary 

We’ve also done a lot of work to improve the visuals that are generated from Q&A. Q&A should be even better at suggesting the best visual following visualization best practices for the specific questions you ask. 

Natural Language improvements for Q&A

Integration with Office/Bing thesaurus

We’ve done a lot of work to also improve core engine inside Q&A by allowing it to automatically understand common synonyms by leveraging Office/Bing data to understand terms which are not mentioned in your data model.

Support for measure tables and better handling of table names and ambiguity

If you have used Q&A before, you would know that Q&A does not work very well when dealing with disconnected tables. This update brings the biggest improvement to Q&A working out of the box automatically by providing automatic handling of disconnected/measure tables and figuring out which measures are related with which dimensions. You no longer need to make a specific data model just for Q&A which we hope will save you countless hours and pain.

Row label and synonyms support inside Modelling pane

This update also brings support for Row labels (formerly known as default labels which were available inside Excel) which allows you to define the row identifier for a table. To define the row label, you can go to the modeling tab and click a table name to see the option. Also, if you wish to define synonyms which are to be used by Q&A you can use the modelling pane to quickly define all the synonyms for all columns inside your data mode.

100319 0140 PowerBIDesk10 Power BI Desktop October 2019 Feature Summary

This month we’re also introducing tooling you can use to see how people are using the Q&A visual and improve the results they’re getting. You can reach this tooling by click on the gear icon.  

100319 0140 PowerBIDesk11 Power BI Desktop October 2019 Feature Summary 

Review questions 

The first section of the tooling allows you to see the questions consumers are asking in your reports. You start out by picking which dataset is used in this report.   

100319 0140 PowerBIDesk12 Power BI Desktop October 2019 Feature Summary 

From there, you’ll see a list of questions that have been asked in the Power BI service from that data. You can filter the list to see either all questions or just the ones where the consumer has asked for you to fix the result to give a better answer. Any questions where Q&A didn’t understand the terms will have a pencil next to them, which will  take you to the next section, Teach Q&A, to fix it.  

Teach Q&A 

The second section in the tooling allows you to teach Q&A how to respond to questions that are ambiguous. You can start by typing in a question such as “Show my best manufacturers” and clicking Submit. 

100319 0140 PowerBIDesk13 Power BI Desktop October 2019 Feature Summary 

Then the terms that Q&A didn’t understand, in this case “best”, are identified, and you’re given an experience to teach Q&A what those terms mean.   

100319 0140 PowerBIDesk14 Power BI Desktop October 2019 Feature Summary 

You can then type in your own custom definition, such as good manufacturers have a high sales amount, see the potential result on the right, and save the definition once you are happy.  

100319 0140 PowerBIDesk15 Power BI Desktop October 2019 Feature Summary 

You can do this for as many terms and questions as needed.

Manage terms 

The last section allows you to manage the terms you’ve added to Q&A through the Teach Q&A section. You’ll see each term, its definition, when it was created, and if you no longer want the term an option to delete it. 

100319 0140 PowerBIDesk16 Power BI Desktop October 2019 Feature Summary

Support for SSAS and Azure AS including RLS

Finally, we now support SQL Server Analysis Services and Azure Analysis services with Q&A allowing you to connect to your data without having to import the data first inside Power BI. In order to use this feature, you must first enable the preview feature switch in options and settings -> options -> preview features.

There are a few limitations that we’ll be addressing over the coming months. You can find the details in the documentation.

If you haven’t already, start using Q&A and provide a truly self-serve experience for your end-users. As always, we would love to hear from your feedback and what you think about the new Q&A experience.

Watch the following video to learn more about the new Q&A visual and tooling:

PowerApps visual is now included by default

Last month, we announced that the PowerApps visual was generally available and certified, and to continue along that vein, this month we’re announcing the visual is now included by default. Instead of needing to add the visual from the marketplace, you’ll find it automatically included with the list of other built-in visuals within the visualization pane. This visual is a key integration with the rest of the Power Platform and enables key scenarios such as writeback and taking immediate data-driven actions on your insights.

New xViz visuals

There are three new visuals as part of the xViz suite. The xViz suite is a set of custom visuals that aim to meet your end-to-end BI needs. You can use all the visuals within the suite for free with their branding and some data row restrictions or you can pay one price to unlock all the visuals. You can learn more about pricing here.

Hierarchical Variance Table

The Hierarchical variance table lets you compare to measures within a hierarchical table layout and see the variance, % variance, and how that contributes to the whole. If you include a date field, you can also see a sparkline within the table.

100319 0140 PowerBIDesk18 Power BI Desktop October 2019 Feature Summary

You can use the number formatting card to apply custom formatting to the measures.

100319 0140 PowerBIDesk19 Power BI Desktop October 2019 Feature Summary

The same card also has a section called semantic formatting that lets you change the color and format based on if the value is negative or positive.

100319 0140 PowerBIDesk20 Power BI Desktop October 2019 Feature Summary

Right-clicking on the row headers will allow you to do things like rearrange the order of the hierarchy, hide or show totals, change the sort order, expand to a specific level of the hierarchy, or show and hide different column headers.

100319 0140 PowerBIDesk21 Power BI Desktop October 2019 Feature Summary

Other formatting options include:

  • Text and background colors for alternating rows
  • Renaming headers
  • Hiding empty rows
  • Adding a search bar (only for the Power BI service)

Find this visual on AppSource.

Linear Gauge

The second visual this month is the Linear Gauge, which allows you to compare a value to a target goal.

100319 0140 PowerBIDesk22 Power BI Desktop October 2019 Feature Summary

In the conditional formatting card of the formatting pane, you can set the band thresholds and colors.

100319 0140 PowerBIDesk23 Power BI Desktop October 2019 Feature Summary

You can also customize the marker shape, size and offset from the bottom for both the actual and target in the gauge options card.

100319 0140 PowerBIDesk24 Power BI Desktop October 2019 Feature Summary

Other formatting options include:

  • Setting minimum and maximum values
  • Axis formatting, including text size, colors, and label density
  • Data label formatting

Get this visual on AppSource.

Tag Cloud

The last visual for this month is the tag cloud. This word cloud visual allows you to get instant insights of the more prevalent terms in your data, such as product descriptions, tweets, and feedback comments.

100319 0140 PowerBIDesk25 Power BI Desktop October 2019 Feature Summary

Some key features and options include:

  • Split phrases into individual words
  • Remove special characters
  • Exclude words
  • Format the word size, color, angles, and number of orientations

You can also control the color and size of the words based on different metrics.

You can find this visual on AppSource.

Watch the following video to learn more about these new visuals:

Sagra Emigo connector generally available

Emigo supports sales organizations and field teams management. It automates all daily activities of field professionals. Inventory data, orders, answers from surveys or all sorts of other digital forms are available for managers and other teams within organization, through the Biqsens Power BI app as well as through Emigo BI Connector for Power BI Desktop.

Azure Cost Management update

Azure Cost Management enhances exploration and analysis of your Azure cost data. With it, you can make powerful and flexible reports to understand your consumption patterns.

What’s new:

  • Supports OAuth 2.0 for authentication
  • Supports both Microsoft Customer Agreement and Enterprise Agreements (EA)
  • Includes enhancements to RI recommendations and RI usage data and the addition of amortized cost
  • Performance improvements

New Workplace Analytics connector

Microsoft Workplace Analytics uses data from everyday work in Office 365 to identify collaboration patterns that impact productivity, workforce effectiveness, and employee engagement. Help your customers speed transformation using new insights about the way their people and teams work.

Query diagnostics

Query Diagnostics is a powerful new feature that will allow you to determine what the Mashup Engine is doing during authoring time. While we’ll be expanding on this feature in the future, including allowing you to use it during full refreshes, at this time it allows you to understand what sort of queries you are emitting, what slowdowns you might run into during authoring refresh, and what kind of background events are happening.

To enable it, enable ‘Query Diagnostics’ under ‘Preview Features’ in Options.

To start diagnostics, in the Power Query Editor click on the ‘Tools’ pane in the Ribbon and select ‘Start Diagnostics’. To finish and aggregate the traces, press ‘Stop Diagnostics’. Whenever you start diagnostics, Power Query will begin tracing any evaluations that you cause.

100319 0140 PowerBIDesk27 Power BI Desktop October 2019 Feature Summary

The evaluation that most users think of is when you press refresh, or when you retrieve data for the first time, but there are many actions that can cause evaluations depending on the connector. For example, with the SQL connector, when you retrieve a list of values to filter, that would kick off an evaluation as well—but it doesn’t associate with a user query, and that’s represented in the diagnostics. Other system-generated queries might include Navigator or “Get Data” experience.

With this first version of the feature, we present two different diagnostic views—a summarized and a detailed view.

The basic view is aimed to give you an immediate insight into where time is being spent in your query. The detailed view is much deeper, line by line, and will generally only be needed for serious debugging by power users.

Some capabilities, like the “Data Source Query” column, are currently available only on certain connectors. We will be working to extend the breadth of this coverage in the future.

You can find more information about Query Diagnostics, including all diagnostics information fields exposed by this feature and their semantics in this documentation article.

Data profiling enhancements

This month we’re introducing a couple of significant enhancements to our Data Profiling capabilities within the Power Query Editor, including:

Multiple Grouping options for the Column Profile pane value distribution visual, specific by column type, in addition to the existing “By Value” criteria:

  • Text: By Text Length (number of characters).
  • Number: By Sign (positive/negative) and Parity (even/odd).
  • Date/DateTime: By Year, Month, Day, Week of Year, Day of Week, AM/PM Time and Hour within a day.
  • And more for other data types (Logical True/False), etc.

100319 0140 PowerBIDesk28 Power BI Desktop October 2019 Feature Summary

Filter options: Not only can you now leverage several type-specific grouping criteria within the Colum Profiles distribution pane but also we’ve enabled filtering from within the callouts for each of the values in the distribution chart when the grouping criteria is applied. For example, you can easily exclude all values that fall in a given Month right from the Data Profiles pane for a Date/DateTime column.

100319 0140 PowerBIDesk29 Power BI Desktop October 2019 Feature Summary

Watch the following video to learn more about our data preparation updates:

Project Web App

This month’s template app aimed at helping project, portfolio and resource managers who work in Project Web App visualize their work. The report model was built using the Project Web App data connector. It can be connected to your own Project Web App data using your own credentials.  This template app is comprised of 13 visually rich report pages to support the PWA management needs.

Below is one of the many Portfolio Management report pages.

100319 0140 PowerBIDesk30 Power BI Desktop October 2019 Feature Summary

And here’s an example of a Resource Management report page.

100319 0140 PowerBIDesk31 Power BI Desktop October 2019 Feature Summary

The reports enable users to do a deep-dive analysis on project management, resource management and portfolio management views. Overall, this report provides a great out-of-box experience for managers using PWA to take their data to the next level.

  • This template includes 6 report pages offering analysis on portfolios of projects including views of a Portfolio Dashboard, Portfolio Timeline, Portfolio Costs, Portfolio Milestones, and Portfolio Issues and Risks.
  • It also includes 5 report pages with analysis on resourcing across projects including views of a Resource Overview, Resource Availability, Resource Assignments, specific Resource Details, and a predictive analysis Resource Demand Forecast.
  • For individual projects, there are 2 report pages with detailed project information for single projects including a dive on Project Status and Project Issues and Risks.

100319 0140 PowerBIDesk32 Power BI Desktop October 2019 Feature Summary100319 0140 PowerBIDesk33 Power BI Desktop October 2019 Feature Summary

You can install the app right in the Power BI service and set its parameters to your PWA site URL, and the language your site is in. Once you install it, the report is now yours, so you can customize and share as much as you want.

To learn more about this template app, check out this template’s documentation.

Download this app from AppSource.

Microsoft partners can create their own template apps to publish in the marketplace. If you’re interested in this, be sure to check out our documentation to get started and latest features blog post.

Watch the following video to learn more about Project Web App Template:

New file format: .pbids

This month we are releasing a new file format: PBIDS, to streamline the “Get Data” experience for report creators in your organization. It’s recommended that admins create these files for commonly used connections to help the getting started experience for new report authors.

When an author opens a .PBIDS file, Power BI Desktop will launch and prompt for authentication to connect to the data source specified in the file. Then the navigation dialog will pop-up and the user will need to select the tables to load into the model. They may also need to select the database(s) if one was not specified in the file. From there the user can start building visualizations or revisit “Recent sources” to load a new set of tables into the model.

For the admin to create this file, they will need to specify in the file the required inputs for a single connection and they can specify the mode of the connection. The “mode” can be either “DirectQuery” or “Import”. If “mode” is missing/null, the user that opens the file in Desktop will be prompted to select DirectQuery or Import.

Here is an example of a PBIDS file for a SQL Server connection:

{

  “version”: “0.1”,

  “connections”: [

    {

      “details”: {

        “protocol”: “tds”,

        “address”: {

          “server”: “<<server-name>>”,

          “database”: “<<db-name (Optional)>>”

        }

      },

      “options”: {},

      “mode”: “DirectQuery”

    }

  ]

}

And here’s an example for a SharePoint list. Please note that the URL must point to the SharePoint site itself and not to a list within the site. The user will get a navigator which allows them to select one or more lists from that site which will each become a table in the model.

{

  “version”: “0.1”,

  “connections”: [

    {

      “details”: {

        “protocol”: “sharepoint-list”,

        “address”: {

          “url”: “<Sharepoint Site URL>”

        }

      }

    }

  ]

}

More examples can be found in our documentation page.

Watch the following video to learn more about this new file format:

Performance improvements for modeling operations

We have made a performance improvement in the Analysis Services engine to speed up modeling operations (such as adding measures or calculated columns, creating relationships, etc.) when the model satisfies the following conditions:

  • Contains a lot of calculations
  • Uses any of the UseRelationship or CrossFilter functions
  • Uses any of the Today, Now, Random, etc. volatile functions

While the actual improvement you’ll see will be highly dependent on the model, we have seen 20x performance improvement for some customers when doing things like opening the file and adding a measure.

That’s all for this month! We hope that you enjoy these updates for the month. Please continue sending us your feedback and don’t forget to vote for other features that you’d like to see in the Power BI Desktop. For any preview features, you can always give us your feedback in our active community. You can also download the .pbix file I used, and if you’re looking for a similar design for your reports, I was using the Microsoft layout from PowerBI.Tips.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop October 2019 Feature Summary

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Read More

Power BI Desktop September 2019 Feature Summary

September 11, 2019   Self-Service BI

You’ll notice one of our exciting updates right away when creating new reports with the September update of Power BI Desktop, a new, modern default theme! Not only do we have a new default theme, but we’ve more than doubled the number of built-in theme options for your report. If you’re a theme author, potentially more exciting are the updates to our theme JSON format which make it much quicker and easier for you to create your own custom themes that significantly change the look and feel of your report. Thanks to an intern project, we’re also releasing a frequently requested modeling feature: custom format strings. And of course, we have plenty of incremental improvements this month, with some performance improvements, more dynamic formatting options, updates to our personalized visualization pane, and more.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop September 2019 Feature Summary

As a final reminder, starting this month, we are only releasing our new single .exe installer that has all the languages wrapped into it. If you’re automatically downloading it from the Download Center each month, you’ll need to update your scripts. You can learn more about how to do this in our documentation. We have also added some guidance at the end of this post.

Here’s the complete list of September updates:

Reporting

Analytics

Visualizations

Data connectivity

Data preparation

Template apps

Other

For a summary of the major updates, you can watch the following video:

Color and text classes in themes

When writing your own custom theme JSON file, we know it can be quite difficult to build a theme that changes the entire look of your report. For example, if you wanted to create a dark theme that set the page to a dark color and use white text on top, you’d have to change a ton of settings through the visual styles section of the JSON, which can be very time consuming and error prone.

To help with this, we’ve expanded the color classes within our theme file to allow you format many of the colors in your theme without needing to touch visual styles. If you’re already writing theme files, you’re likely already using a few existing color classes: foreground, background, and tableAccent, which update various settings within your report with one line. With this update, we’re adding new color classes to that list, which as a result, means you can color all visual elements in a report just by setting 6 colors.

The color classes you now have available and what they format are:

In addition to color classes, we’ve added text classes to make it easier and quicker to set text styles. There are 4 primary text classes that adjust a total of 14 total text classes. You can set the font family, font size, and font color for each text classes. The four main text classes are: “Title”, “Label”, “Callout”, and “Header”.

The Title and Label classes have several secondary classes that are automatically derived from the primary class settings but can be formatted individually. For example, if you set the label class, which for example is used for the values in a table to 10pt, a “Small Label,” which is for example used the search box text in slicers, would be automatically set to 9pt. The goal of the primary/secondary text classes is to make it quick and easy for you to set the text classes, which still maintaining a visual hierarchy to the text.

The below table shows the primary classes with example settings and the secondary classes with the settings that make them unique compared to their associated primary class.

Primary class Secondary classes Class name in JSON Settings Associated visual objects
Callout N/A callout DIN

#252423

45pt

Card data labels

KPI indicators

Header N/A header Segoe UI Semibold

#252423

12pt

Key influencers headers
Title title DIN

#252423

12pt

Category axis title
Value axis title
Multi-row card title *
Slicer header
Large title largeTitle 14pt Visual title
Label label Segoe UI

#252423

10pt

Table and matrix column headers
Matrix row headers
Table and matrix grid
Table and matrix values
Semibold semiboldLabel Segoe UI Semibold Key influencers profile text
Large largeLabel 12pt Multi-row card data labels
Small smallLabel 9pt Reference line labels *
Slicer date range labels
Slicer numeric input text style
Slicer search box
Key influencers influencer text
Light lightLabel #605E5C Legend text
Button text
Category Axis labels
Funnel chart data labels
Funnel chart conversion rate labels
Gauge target
Scatter chart category label
Slicer items
Bold boldLabel Segoe UI Bold Matrix subtotals
Matrix grand totals
Table totals
Large and Light largeLightLabel #605E5C

12pt

Card category labels
Gauge labels
Multi-row card category labels
Small and Light smallLightLabel #605E5C

9pt

Data labels
Value axis labels

* The font color for these settings is based on the data colors, not the text class settings.

For example, here’s a small theme that sets some of these properties:

{
 "name": "NewThemeOptions",
 "foreground": "#252423",
 "foregroundNeutralSecondary": "#605E5C",
 "foregroundNeutralTertiary": "#B3B0AD",
 "background": "#FFFFFF",
 "backgroundLight": "#F3F2F1",
 "backgroundNeutral": "#C8C6C4",
 "tableAccent": "#118DFF",
 "textClasses": {
      "callout": {
           "fontSize": 45,
           "fontFace": "DIN",
           "color": "#252423"
      },
      "title": {
           "fontSize": 12,
           "fontFace": "DIN",
           "color": "#252423"
      },
      "header": {
           "fontSize": 12,
           "fontFace": "Segoe UI Semibold",
           "color": "#252423"
      },
      "label": {
           "fontSize": 10,
           "fontFace": "Segoe UI",
           "color": "#252423"
      }
 }
}

You can still use visual styles to set any specific formatting you want, and that will override any color or text classes that have been set. We expect with these new changes for most users to stick to the color and text classes the majority of the time, and only use the visual styles for non-color/text options (such as turning titles on/off by default).

Watch the following video to learn more about color and text classes:

New default themes

To go along with the new theme JSON options, we are also updating the themes available for reports and changing the default theme for new reports.

090519 0712 PowerBIDesk1 Power BI Desktop September 2019 Feature Summary

Our design and research team spent quite a bit of time developing a new set of themes that have more variety (such as Innovate, a dark theme) and show off more theme-able feature (such as Bloom, with it’s background image).

090519 0712 PowerBIDesk2 Power BI Desktop September 2019 Feature Summary

The new default theme is meant to both align better with Microsoft’s design language and follow best design practices for visuals. We also tested it thoroughly to ensure it’s design is an improvement over other themes, with the goal that the new default makes it easier to create beautiful reports out of the box.

090519 0712 PowerBIDesk3 Power BI Desktop September 2019 Feature Summary

Some visual updates with the new default theme are:

  • Larger, darker, more readable text
  • Smaller bubble sizes for scatter and map visuals
  • Wider line strokes for line and combo charts
  • Updated layout for pie and donut charts to improve readability
  • Expand/collapse on by default for matrices
  • Backgrounds on for visuals by default

You can still find the previous themes under the “More themes” submenu any time you want to reach them. One thing to remember around custom themes is that they always build on top of the default theme. So for example, if you created your own custom theme that just set the data colors and nothing else, if you imported that theme into a report with the new default applied, it would still have expand/collapse on by default, backgrounds on for visuals, etc., so it may look different compared to when you imported it to a report with the old default theme. If you want your theme to look exactly the same way it did previously, you can first set the theme to “Classic” in the theme dropdown, so the default theme has the old settings and then import your custom theme.

Watch the following video to learn more about our new themes:

Personalized visualization pane improvements (preview)

Unpin default visuals

The first update to the personalized visualization pane this month is the ability to unpin any of the default visuals.

090519 0712 PowerBIDesk4 Power BI Desktop September 2019 Feature Summary

Once you unpin a built-in visual, it moves under the dotted line within the pane, and next time you open a report, it won’t show unless you have that visual type used already within the report, in which case, it will show below the dotted line. This means that the only difference in experience between built-in and custom visuals is that the built-in ones show by default initially.

Some reasons you might want to do this include:

  • You never use specific visuals and want to declutter the pane
  • You have strong feelings against specific visual types and don’t want to see it as an option
  • You’re using a custom visual version of a visual type and don’t want to be mistakenly click on the built-in version you never use.

If you later want the default visuals back, you can use an option to restore the original visuals to the pane.

090519 0712 PowerBIDesk5 Power BI Desktop September 2019 Feature Summary

About info for visuals

Another update is that you can now right click on any visual in the visualization pane to see an About dialog with more information on the visual.

090519 0712 PowerBIDesk6 Power BI Desktop September 2019 Feature Summary

You’ll be able to see things such as the visual’s id, version number, where you got the visual from, and the support information.

090519 0712 PowerBIDesk7 Power BI Desktop September 2019 Feature Summary

Watch the following video to learn more about the personalized visualization pane improvements:

Custom format strings

While in the modeling view, you can now enter in a custom format string to customize how the field will show in visuals.

To do this, first select the field in the fields list and select the custom format option in the formatting card of the properties pane.

090519 0712 PowerBIDesk8 Power BI Desktop September 2019 Feature Summary

From there, you’ll be able to select from a list of commonly used format strings.

090519 0712 PowerBIDesk9 Power BI Desktop September 2019 Feature Summary

Or you can use the given an input box to enter in your own format string. Power BI will support most of the VBA style syntax, with a few exceptions. Refer to the full documentation for details.

090519 0712 PowerBIDesk10 Power BI Desktop September 2019 Feature Summary

Once you enter in your custom format string, it will immediately be reflected in the data view and report view.

One of our returning interns, Chelsie Eiden, worked on this feature over the summer. You might remember her from the theme picker that she worked on last year! It’s great to have interns come back to the Power BI team – hopefully you’ll see more of Chelsie again in the future.

090519 0712 PowerBIDesk11 Power BI Desktop September 2019 Feature Summary

Watch the following video to learn more about custom format strings:

Conditional formatting for more visual formatting options

We’re excited to announce more formatting features this month that can be conditionally formatted, moving us ever closer to our goal of everything within the formatting pane being conditionally formattable.

Alt text (General)

Alt text is the first feature that now has conditional formatting. This is really a huge step forward in terms of accessibility. Alt text, which is read off by screen readers whenever the visuals are in focus, can now be dynamically changed based on the current filter state of the visual. You can for example call out in the alt text both the highest and the lowest categories and have confidence it will always reflect the current data in the visual.

090519 0712 PowerBIDesk12 Power BI Desktop September 2019 Feature Summary

Border color (Border)

Border color is the next feature that has this added capability. Just as you can with backgrounds, you can dynamically adjust the border color based on current filter state. This could be a good option to use if you want to color a visual based on a specific KPI but you felt like the background color was too intense of an option.

090519 0712 PowerBIDesk13 Power BI Desktop September 2019 Feature Summary

Gauge colors

Back in June, we added conditional formatting to fill color for gauge, and this month we are expanding that to four other gauge properties as well:

  • Target text color

    090519 0712 PowerBIDesk14 Power BI Desktop September 2019 Feature Summary

  • Target fill color
    090519 0712 PowerBIDesk15 Power BI Desktop September 2019 Feature Summary
  • Data label color
    090519 0712 PowerBIDesk16 Power BI Desktop September 2019 Feature Summary
  • Callout value color
    090519 0712 PowerBIDesk17 Power BI Desktop September 2019 Feature Summary

Watch the following video to learn more about the conditional formatting updates:

Drill through discoverability improvement

We’ve heard feedback that end users don’t always know when they can drill through on a visual to another report page. To help with this, we’ve added text to the visual’s tooltip to let them know it’s enabled.

090519 0712 PowerBIDesk18 Power BI Desktop September 2019 Feature Summary

Watch the following video to learn more about the drill through discoverability improvement:

New DAX expressions: REMOVEFILTERS and CONVERT

We have two new DAX expressions this month! REMOVEFILTERS is the same as ALL when used inside CALCULATE to remove filters. CONVERT changes the expression to another data type.

PowerApps visual now generally available and certified

The PowerApps marketplace visual allows you to add the power of apps to reports and dashboards. The PowerApps visual brings forms and data editing directly to Power BI by allowing you to embed your own PowerApps right in your report or dashboard. And as of this month, the visual is now generally available and certified, allowing you to use the visual in even more places.

090519 0712 PowerBIDesk19 Power BI Desktop September 2019 Feature Summary

Try out the visual now.

PostgreSQL connector enhancements

Support for folding over Native Database queries

The PostgreSQL connector has been enhanced with query folding over a native query. You can now paste in a native query when connecting to a PostgreSQL database, with folding capable operations applied on top according to normal Import or Direct Query logic. 

090519 0712 PowerBIDesk20 Power BI Desktop September 2019 Feature Summary

DirectQuery support generally available

We’re happy to announce that the DirectQuery support within the PostgreSQL connect that we announced last month is now generally available.

Copy to clipboard from data profiling

With this month’s release we’re making it possible to export data profiling information by copying it to the clipboard from the Power Query Editor. 

The new Copy option is available from all Data Profiling surfaces as described below.

Data Profiling Surface

Screenshot

Data exported to clipboard

Column Quality Summary

090519 0712 PowerBIDesk21 Power BI Desktop September 2019 Feature Summary

090519 0712 PowerBIDesk22 Power BI Desktop September 2019 Feature Summary

Column Distribution charts

090519 0712 PowerBIDesk23 Power BI Desktop September 2019 Feature Summary

090519 0712 PowerBIDesk24 Power BI Desktop September 2019 Feature Summary

Column Profile Details Pane – Column statistics

090519 0712 PowerBIDesk25 Power BI Desktop September 2019 Feature Summary

090519 0712 PowerBIDesk26 Power BI Desktop September 2019 Feature Summary

Column Profile Details Pane – Column distribution

090519 0712 PowerBIDesk27 Power BI Desktop September 2019 Feature Summary

090519 0712 PowerBIDesk28 Power BI Desktop September 2019 Feature Summary

Watch the following video to learn more about copy to clipboard from data profiling:

Template apps are a great way to provide Power BI users with installable, ready to use, actionable – quality applications. These templates contain reports, dashboards, and data models that can connect to the user’s data, creating immediate value and action. Each month, we’re highlighting a recent template app that’s released to the marketplace.

Google Analytics report

This month template app is one of the more popular template apps Google Analytics report by Havens consulting. The report model was built using the Google Analytics data connector. It can be connected to your own Google Analytics data using your own credentials.

090519 0712 PowerBIDesk29 Power BI Desktop September 2019 Feature Summary

The report itself enables users to do a deep-dive analysis on daily page views with: forecasting and adjustable rolling average, month-over-month traffic gain or loss, top pages visited, traffic source trends over time, and more. Plus, the report contains many great examples of Power BI features and functionality including bookmarks, what-if parameters, advanced conditional formatting, and custom visuals. Overall this report provides a fantastic out-of-the-box Power BI experience and is a great way to supercharge your Google Analytics data.

090519 0712 PowerBIDesk30 Power BI Desktop September 2019 Feature Summary090519 0712 PowerBIDesk31 Power BI Desktop September 2019 Feature Summary

You can install the app right in the Power BI service and set its parameters to your google analytics view ID. Once you install it, the report is now yours, so you can customize and share as much as you want.

Microsoft partners can create their own template apps to publish in the marketplace. If you’re interested in this, be sure to check out our documentation to get started.

Download this app from AppSource.

Performance improvements for multi-dimensional models

This month we’ve done work that gives users of Analysis Services 2019 multi-dimensional users general performance improvements. When using the new Release Candidate of SQL Analysis Services 2019 (see https://powerbi.microsoft.com/en-us/blog/whats-new-for-sql-server-2019-analysis-services-rc1/ for details), you’ll see more performant queries and optimization of measure execution. This improvement, which some may know as “Super DAX”, helps reduce the chattiness between Power BI and Analysis Services. Some other features that come with this is multi-dimensional support for expand/collapse on row headers, cross-highlighting support across different tables, and high density sampling for visuals that support it. You will need to enable this setting in Analysis Services to take advantage of it in Power BI.

Query performance improvements for DirectQuery models

This month, we’ve also introduced runtime constant folding to improve query performance for some DirectQuery models. The amount of performance improvements you’ll see will vary depending on the DAX expressions you’re using, the model structure, speed of the DirectQuery source, etc. However, with some early users, we’ve seen some quite significant performance gains.

That’s all for this month! We hope that you enjoy these updates for the month. Please continue sending us your feedback and don’t forget to vote for other features that you’d like to see in the Power BI Desktop. For any preview features, you can always give us your feedback in our active community. You can also download the .pbix file I used, and if you’re looking for a similar design for your reports, I was using the Microsoft layout from PowerBI.Tips.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop September 2019 Feature Summary

* Other considerations on extracting MSI from EXE
Installing Power BI Desktop on remote machines

If you’re deploying Power BI Desktop to your users with a tool that requires a Windows installer file (.msi file) you can extract the .msi file from the Power BI Desktop installer .exe file. You can use third-party tools such as the WiX Toolset to do this.

Note: As a third-party product, WiX Toolset options might change without notice. Please check their documentation for the most up to date information, and contact their user mailing list for help.

  • On the computer where you downloaded the Power BI Desktop installer, download and install the latest version of the WiX Toolset from the WiX website at https://wixtoolset.org/.
  • Open a command line windows as an administrator and navigate to the folder where you installed WiX Toolset.
  • Run the following command: Dark.exe <path to Power BI Desktop installer> -x <output folder>

For example, run:

Dark.exe C:\PBIDesktop_x64.exe -x C:\output

  • The output folder will contain a folder named ‘AttachedContainer’ that includes the .msi files.
Using command-line options during installation

When installing Power BI Desktop, you can set properties and options with command-line switches. This is especially useful for administrators who manage or facilitate the installation of Power BI Desktop across organizations. These options apply to .msi and .exe installations.

Command-line option Behavior
-q, -quiet, -s, -silent silent install
-passive only show the progress bar during installation
-norestart suppress the computer restart requirement
-forcerestart restart the computer after installation without a prompt
-promptrestart prompt the user if computer restart is required (default)
-l<>, -log<> log the installation to a specific file, with the file specified in <>
-uninstall uninstall Power BI Desktop
-repair repair the installation (or install if it’s not currently installed)
-package, -update install Power BI Desktop (default, as long as -uninstall or -repair aren’t specified)
Syntax parameters

The following properties are specified with a “PROPERTY=VALUE” syntax:

ACCEPT_EULA Requires a value of 1 to automatically accept the EULA
ENABLECXP Value of 1 enrolls in the customer experience program that captures telemetry on usage of the product
INSTALLDESKTOPSHORTCUT Value of 1 adds a shortcut to the Desktop
INSTALLLOCATION File path to where you want it installed
LANGUAGE Locale code e.g. en-US, de-DE, pr-BR to force the default language of the application. If no language is specified, Power BI Desktop displays the Windows OS language. This can be changed by the user in the Options dialog.
REG_SHOWLEADGENDIALOG Value of 0 disables showing the dialog that appears before you have signed in to Power BI Desktop

As an example, you’d run it with the following to install without any UI, using the German language: “-quiet LANG=de-DE ACCEPT_EULA=1”

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Read More

Power BI Desktop August 2019 Feature Summary

August 15, 2019   Self-Service BI

Our August release has another hotly anticipated feature from the Microsoft Business Application Summit, grouping. Grouping in reports, similar to PowerPoint’s grouping, lets you easily organize groups of visuals to move and resize them as a set. This month’s release also has some updates to our newest features, such as an icon set picker for our newly added icons conditional formatting and measure support for key influencers.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop August 2019 Feature Summary

As a reminder, you’re now downloading a single .exe file that has all the languages wrapped into it. The old .msi installation is still available from the Download Center, but we’ll be deprecating that in September. If you’re automatically downloading it from there each month, you’ll need to update your scripts. If you want to know more about deploying Power BI Desktop remotely through scripts read our documentation.

Here’s the complete list of August updates:

Reporting

Analytics

Visualizations

Data connectivity

Template apps

For a summary of the major updates, you can watch the following video:

Grouping visuals

We are very happy to announce the release of one of the most exciting demos from the Microsoft Business Applications Summit, grouping. Grouping allows you to group visuals, shapes, textboxes, images, and buttons together on your report page just like you can do in PowerPoint. Once objects are grouped together, you’ll be able to move and resize them all together. This should make it a lot easier to work with reports with lots of objects layered on each page.

080619 0037 2019AugustD1 Power BI Desktop August 2019 Feature Summary

To group visuals, you can ctrl+click them and right click to select the group option.

080619 0037 2019AugustD2 Power BI Desktop August 2019 Feature Summary

Right-clicking a group will give you an option to ungroup them later.

Generally, by default, the behavior mimics PowerPoint exactly, such as:

  • Clicking on the empty space within the group will not select anything
  • Clicking on a visual within a group will select the entire group on first click and the individual visual on second click
  • Selecting a group and another object on the page and then selecting the Group option will create a nested group
  • Use the selection pane to hide everything in the group at once (and bookmark it if you)

There are a few ways we’ve extended the feature as well, including:

  • Use the selection pane to drag and drop objects in and out of groups
  • Selecting two groups and opening the context menu will give you an option to merge the groups into one group instead of nesting them
  • Using the formatting pane, you can add a background color to a group. If a group has a background, it now has “substance” so you can click on the background of the group to select it.

080619 0037 2019AugustD3 Power BI Desktop August 2019 Feature Summary

Groups, since they aren’t actual content on the report page, don’t affect the tab order of your report page. Grouping is also only supported on reports using our new modern header, so if you have an older report still using the previous header, upgrade it in the Options dialog to take advantage of this feature.

We have more plans for grouping the future as well. In a future update, we’ll add different modes to grouping that will change the way the visuals and the group’s container interact with each other. For example, you’ll eventually be able to create a group that scrolls.

Watch the following video to learn more about grouping:

Filter pane auto-update

Last month, we announced the general availability of our new filter pane, and now we are starting the process to transition current reports to the new pane as well. We obviously want to do this in a way that will minimize the impact on your current reports. With that in mind, this month, when you open Power BI Desktop for the first time, we’ll show you a filter pane auto-update dialog. Make sure to take advantage of this opportunity, as we will eventually auto-update all existing report to the new filter pane.

080619 0037 2019AugustD4 Power BI Desktop August 2019 Feature Summary

Through this dialog, you can opt into using the new filter pane experience. Once you do this, anytime you open an old report it will show the new filter pane automatically. If you save the report after opening it, the new pane will now persist, and once you publish the report again, it will show for you end users. If you’re not ready to upgrade a specific report, you can turn off the new pane through the report level settings in the options dialog.

080619 0037 2019AugustD5 Power BI Desktop August 2019 Feature Summary

If you’re not ready to switch to the new experience, you can close out the auto-update dialog or choose to opt out at this time. You’ll still see the old pane for your reports, but when you’re ready, you can opt in through the dialog the next time you open a report.

Icon style picker for Icons conditional formatting

Last month, we released a new form of conditional formatting, called Icons, that allows you to add icons next to values in your table or matrix based on custom business logic. This month we are improving the usability of this feature by adding an icon set picker to the dialog. This will give you a fast way to select a set of icons and rules to start with and then customize from there, which should save you some time manually selecting icons for each individual rule.

080619 0037 2019AugustD6 Power BI Desktop August 2019 Feature Summary

Watch the following video to learn more about icon styles:

Conditional formatting warnings

Over the last several months, we’ve expanded the number of places you can apply conditional formatting to include settings such as titles and font colors to name just a few. As we’ve mentioned before, our goal is to eventually support conditional formatting for most, if not all, formatting properties. Given how prevalent conditional formatting will become with all these changes, we also wanted to make it easy to see errors in your conditional formatting configuration.

080619 0037 2019AugustD7 Power BI Desktop August 2019 Feature Summary

Now, we’ll show a warning in the visual header and the formatting pane if one of the following cases is true:

  • The measure’s data type is not what the formatting property expects (e.g. the measure returns a number, but the property is a string)
  • The measure used to conditionally format was deleted
  • The measure returns an unrecognized value (ex. Rad instead of Red)

These warnings will only show up when editing a report, end users won’t see the warnings when viewing the report.

Watch the following video to learn more about conditional formatting warnings:

Key influencers improvements

Measure support

You can now use measures in the Analyze bucket of the key influencers visual. By default, we’ll evaluate the measure based on the fields you include in the Explain by bucket. There’s also a new Expand by bucket in the field well that can be used to refine the level that the measure in the analyze bucket is evaluated at. For example, if you want it to be evaluated over all your data, you can add an ID field to the Expand by bucket.

080619 0037 2019AugustD8 Power BI Desktop August 2019 Feature Summary

General availability

With measure support now added, we are very excited to announce the general availability of the key influencers visual. Thank you for all the feedback given during the preview period!

Watch the following video to learn more about the Key influencers visual improvements:

xViz visualization suite by Visual BI

Visual BI, the makers of the ValQ value driver tree visual, are releasing a suite of new visuals available in AppSource called xViz. These in-app purchase visuals are highly customizable and are completely free up until 2000 data points. After that, they have a licensing plan in place that gives you access to all visuals within the suite for one price.

Multiple axis chart

The first visual within the xViz suite is the multiple axis chart. This visual allows you to display up to five separate axis values, each with a unique visual type: column, column stacked, line, spline, area, area stacked or area spline.

080619 0037 2019AugustD10 Power BI Desktop August 2019 Feature Summary

To build out this visual, you’ll start by placing the categorical axis field in the Axis bucket. From there, you’ll place each measure you want to display in the value axis buckets. When you place several measures within the same value axis bucket, they’ll share the axis and if you place them in different buckets, they will each have either own unique axis.

080619 0037 2019AugustD11 Power BI Desktop August 2019 Feature Summary

From there, there are tons of customizations you can do in the formatting pane. You can customize the visual type using the Series Type card, mixing and matching to get the visual layout you’re looking for.

080619 0037 2019AugustD12 Power BI Desktop August 2019 Feature Summary

Some other unique options this visual has include:

  • Error bars, horizontal and vertical bands, and horizontal reference lines found in the Analytics card
  • A utility menu that allows end users on the Power BI service to export PNGs, lasso select, and zoom (This menu is only supported in the service, not Power BI Desktop).
  • Adding pattern fills using the Data Series Pattern card to improve accessibility of your visuals
  • Advanced formatting controls for each axis shown in the visual
  • Custom text and URL footer through the Miscellaneous card

You can click on the grid icon on the top right of the visual to flip to a table view of the data and filter the rows through a search bar.

080619 0037 2019AugustD13 Power BI Desktop August 2019 Feature Summary

You can also click on the pencil icon to open a conditional formatting menu which allows you to write complex conditional formatting rules to apply to any series in the visual. The rules will automatically show in the legend as well (this can be turned off in the formatting pane if needed).

080619 0037 2019AugustD14 Power BI Desktop August 2019 Feature Summary

The conditional formatting and either be based on rules or on a color scale.

080619 0037 2019AugustD15 Power BI Desktop August 2019 Feature Summary

By combining all these features together, you can create complex and robost visuals to show your data however you need.

080619 0037 2019AugustD16 Power BI Desktop August 2019 Feature Summary

Check out this visual on AppSource.

Watch the following video to learn more about the Multiple axis chart:

Marimekko chart

The Marimekko chart, the second xViz visual, lets you visualize categorical data over two scales, using both width and height, to show the relationship between them. You start off this visual with a categorical value you want to show on the value axis From there you can add a measure to define the height of each category and a different measure to set the width. You can also add a category to the legend to split the data further.

080619 0037 2019AugustD17 Power BI Desktop August 2019 Feature Summary

Since this visual is part of the xViz suite, it has the same great formatting options we’ve already covered for the Multi-axis chart, including the powerful conditional formatting options and advanced formatting control.

Download this visual from AppSource.

Watch the following video to learn more about the Marimekko chart:

Variance chart

The variance chart, the third visual in the xViz suite, allows you to easily compare multiple metrics, such as forecast versus budget, and see the variance between them. For this visual, you need to add your categorical field, such as time, to the Category bucket in the field well. From there you add the first value you want to compare in the Actual value bucket and the second to the Comparison value bucket. The visual will then show a comparison chart with both values, a variance chart, and a percent variance chart.

080619 0037 2019AugustD18 Power BI Desktop August 2019 Feature Summary

In addition to all the general formatting capabilities you get with all xViz visuals, such as conditional formatting, you also have a lot of controls specific to this visual type. For example, you can choose to customize which of these chart types you want to include in the visual and how much space they take up within the Chart Options card of the formatting pane.

080619 0037 2019AugustD19 Power BI Desktop August 2019 Feature Summary

You can switch the style of the variance percent chart between oval and square through the formatting pane as well.

080619 0037 2019AugustD20 Power BI Desktop August 2019 Feature Summary

You can even change the chart type used for the comparison chart.

080619 0037 2019AugustD21 Power BI Desktop August 2019 Feature Summary

You’ll find this visual on AppSource.

Watch the following video to learn more about the Variance chart:

Horizon chart

Lastly, the Horizon chart, which I covered last September, has been upgraded and integrated into the xViz suite.

080619 0037 2019AugustD22 Power BI Desktop August 2019 Feature Summary

Find this visual on AppSource.

Watch the following video to learn more about the Horizon chart:

Support for SAP HANA HDI Containers

The SAP HANA connector has been enhanced in this month’s release to enable consumption of views under HANA Deployment Infrastructure (“HDI”) Containers.

Views within HDI Containers are seamlessly showed within the Navigator dialog when using the SAP HANA connector, allowing you to consume them with either Import or DirectQuery mode and operate over them just like with any other view within SAP HANA.

Edit SAP variables in Power BI service (preview)

When using SAP Business Warehouse or SAP HANA with DirectQuery, you can now allow end users to edit SAP variables in the Power BI service
for Premium workspaces.

Note: This is a preview feature that requires the new filter experience and an SSO-enabled gateway. For full details on setup requirements, check out the documentation.

Watch the following video to learn more about editing SAP variables:

PostgreSQL DirectQuery

Another connector enhancement this month provides DirectQuery support within the PostgreSQL connector, enabling you to build reports on top of their PostgreSQL databases without the need to import data.

When launching the PostgreSQL connector, you can now specify DirectQuery as your connectivity mode choice within the connector dialog.

080619 0037 2019AugustD23 Power BI Desktop August 2019 Feature Summary

MarkLogic connector now generally available

We’re glad to announce that the MarkLogic connector is now generally available. The MarkLogic connector can be found within the Database category in the Get Data dialog.

080619 0037 2019AugustD24 Power BI Desktop August 2019 Feature Summary

New Power Platform  category within Get Data

With this month’s release, we’re renaming the Power BI category under Get Data to Power Platform, and bringing the Common Data Service connector into this category, in addition to the Power BI datasets and Power BI dataflows connectors.

This change also lays the foundation for several other enhancements coming to Power BI that will leverage other Power Platform capabilities provided by PowerApps, Flow, and the Common Data Service. Stay tuned!

Facebook Pages – Basic Analysis

Template apps are a great way to provide Power BI users with installable, ready to use, actionable – quality applications. These templates contain reports, dashboards, and data models that can connect to the user’s data, creating immediate value and action.

We are going to start regularly sharing new or popular template apps in this blog, and first up is the Facebook Pages – Basic Analysis template app by DataChant, which provides marketing professionals the simplest way to analyze any Facebook page in Power BI without being the page administrator.

You can install the app right in the Power BI service and set its parameters to import data about up to four Facebook pages.

Once you complete the short set up flow, you’ll be given a dashboard and report that shows how each page performs over time based on their number of posts and shares. Even if you’re not a social media analyst, you can use this template app as a great demo tool to showcase Power BI capabilities. The dashboard and report are now yours, so you can customize and share as much as you want.

Microsoft partners can create their own template apps to publish in the marketplace. If you’re interested in this, be sure to check out our documentation to get started.

Download this app from AppSource.

That’s all for this month! We hope that you enjoy these updates for the month. Please continue sending us your feedback and don’t forget to vote for other features that you’d like to see in the Power BI Desktop. For any preview features, you can always give us your feedback in our active community. You can also download the .pbix file I used, and if you’re looking for a similar design for your reports, I was using the Microsoft layout from PowerBI.Tips.

5d7f8edd 60a2 45e6 8cd8 5a7fa35e97b5 Power BI Desktop August 2019 Feature Summary

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Read More
« Older posts
  • Recent Posts

    • Rickey Smiley To Host 22nd Annual Super Bowl Gospel Celebration On BET
    • Kili Technology unveils data annotation platform to improve AI, raises $7 million
    • P3 Jobs: Time to Come Home?
    • NOW, THIS IS WHAT I CALL AVANTE-GARDE!
    • Why the open banking movement is gaining momentum (VB Live)
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited