What are those new buttons under tab order in Power BI?

Published On: 2021-11-28By:

If you’ve visited the Tab order area of the Selection Pane in Power BI in the last couple of months, you might have noticed some new buttons.

The selection pane in Power BI desktop with Tab order selected. There are three buttons underneath the Tab order heading.
Three new buttons for managing tab order in Power BI

The hover text on the first button says “Expand All”. This button is useful if you have grouped visuals. Groups are indicated by a carat to the left of the item in the tab order list.

The selection pane with tab order showing. The fourth item is a group titled Summary Cards. The items within the group are not shown.
Tab order for a report page containing one group

Selecting the Expand all button shows the individual objects within a group.

The selection pane with tab order showing. The fourth item is a group titled Summary Cards. The items within the group are shown in an indented list under the group name.
Tab order with the group expanded

The second button is the Collapse All button. It will collapse the groups so only the name of the group is shown and not the individual objects within the group.

The third button is a great new addition: Have tab order match visual order.

The Selection pane is shown with Tab order selected. The third button has hover text that reads "Have tab order match visual order".
The option to have tab order match visual order is the third button under Tab order.

This button will set the tab order for the visuals on the page to sort ascending by Y and then X coordinates. Let’s look at an example.

I have a report page containing 7 textboxes.

A Power BI report page with a box in the top left corner and a grid of 6 boxes underneath, spanning the entire width of the report. The order of the boxes appears random, but it matches the order in which they were added to the page.
The X,Y coordinates of each box are shown in the box. The original tab order is indicated by the numbers in the circle.

After clicking the button to have tab order match visual order, the tab order is changed shown below.

A Power BI report page with a box in the top left corner and a grid of 6 boxes underneath, spanning the entire width of the report. The order of the boxes matches the Y and X coordinates of each visual, starting at the top left and moving down to the bottom right.
Tab order set with the top left visual being first and the bottom right visual being last

This is often the correct tab order that matches how we read the report visually. This little button can increase keyboard/screen reader accessibility in one second instead of taking a couple of minutes per page.

There will be times that this tab order will not be what you want. Some exceptions might be when you use visuals that have a different amount of space inside the visual container, so the containers are intentionally misaligned (according to the X,Y coordinates) in order for the content to appear visually aligned. Then you might need to customize your tab order a bit. Another exception might be if you have some buttons or links at the top right of the report page that you want a user to visit last (after the content of the report). In that case, you would customize your tab order to make the button last.

But the majority of the time, this option to make tab order match visual order is exactly what you need. I applaud the Power BI team for taking this step to make creating accessible reports a little easier.

Contact the Author | Contact DCAC

Viewing Azure Site to Site VPN Logs in Log Analytics

Published On: 2021-11-15By:

Recently I needed to view the logs from an Azure Site to Site VPN to see why it wasn’t working as expected. When Azure Site to Site VPNs aren’t working as expected the GUI falls apart quickly for troubleshooting.

Log Analytics is where this problem gets solved. Log Analytics is going to allow you to see basically everything that the Azure Network Gateway is doing. Setting the feed up to Log Analytics isn’t as straightforward as it could be, but it is documented in this post.

In order to view the data, open the Azure Network Gateway in the Azure Portal and find the “Logs” option under “Monitoring” on the menu on the left. This will open the Log Analytics query editor. Cancel out of the sample queries that it gives you access to.

The following query will show you the messages that you are receiving from the IKE Diagnostics.

AzureDiagnostics
| where TimeGenerated > ago(24h)
| where Category == “IKEDiagnosticLog”
| project TimeGenerated, Resource, Message
| order by TimeGenerated desc

The following query will show you the messages that are being logged by the site-to-site VPN Tunnel itself.

AzureDiagnostics
| where TimeGenerated > ago(24h)
| where Category == “TunnelDiagnosticLog”
| project TimeGenerated, Resource, stateChangeReason_s
| order by TimeGenerated desc

With the information provided from these queries you should be able to troubleshoot just about any VPN issue that you are seeing when setting up the Azure Site to Site VPN.

Denny

Contact the Author | Contact DCAC

Setting up Azure Network Gateway Logging

Published On: 2021-11-08By:

If you’ve ever set up an Azure Network Gateway for Site to Site or Person to Site VPNing you’ve probably wanted to be able to see logging from the gateway. In the Azure portal, you can see a Logs option, but all it does is tell you to set up log analytics and the link that it gives you is … less than helpful.

In order to set up Log Analytics for your Azure Network Gateway (or other Azure resources that don’t have a direct way to configure diagnostics), you need to configure the Azure Monitor. To find the Azure Monitor search for “monitor” in the search bar within the Azure Portal. Once you find Monitor click on the Monitor option.

From here scroll down on the menu and find the settings section. In this section, you’ll find a “Diagnostic Settings” option. Select “Diagnostic Settings”.

This will bring up a screen that includes a subscription selector, a resource group selector, and a resource type selector. Select the subscription that contains the resource, and the page will refresh with the resources in that subscription. If needed filter down the list based on the resource group and resource type. Once you have found the resource you wish to add to Log Analytics, select the resource and another page will open.

On the new page, you’ll see that there are no diagnostic settings defined. Click on the “Add diagnostic settings” link and a new page will open. This new page will allow you to select the Log Analytics workspace that you will send the data to as well as the kind of data that you want to be logged in addition to a same for the settings.

Set the name, the kind of data that you want to send to Log Analytics, and the Log Analytics workspace that you want to send the data to.

Click OK to save the settings, and if needed close the window (it doesn’t always close in my experience). At this point (or in a few minutes) the Logs option on the resource should work correctly and allow you to view the data in Log Analytics related to the resource.

Denny

Contact the Author | Contact DCAC

Power BI, Maps, and Publish to Web

Published On: 2021-10-14By:

October 2021 is mapping month over at Workout Wednesday for Power BI. As part of our challenges, we build a sample report and use the Publish to Web functionality to share it on the website. While this has worked well all year, there are some visuals, including maps, that do not support or require a different license for use with Publish to Web.

It’s frustrating to build a Power BI report that you plan to share, only to find that you can’t share it. So I thought it would be helpful to consolidate what I have found about the various map visuals and their support of Publish to Web.

Disclaimer: This information is correct as of October 14, 2021. This could change over time. This is not an exhaustive list of all the map visuals available for Power BI.

Map Visuals

6 map visuals on a power bi report: a bubble map, filled map, shape map, ArcGIS map, Azure Map, Mapbox map.
Examples of the 6 map visuals tested with Publish to Web

Note: I also tested several other AppSource visuals, but they failed to render in Power BI desktop. I may update this post if they start working again.

I hope this helps you plan your visuals when you need to publicly share a report that contains a map.

Contact the Author | Contact DCAC
1 2 3 497

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Award 2021 Gold    American Business Award 2021 Bronze    FT Americas’ Fastest Growing Companies 2021   INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award
FT Americas’ Fastest Growing Companies 2020       Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award
Share via
Copy link