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 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.
Selecting the Expand all button shows the individual objects within a group.
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.
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.
After clicking the button to have tab order match visual order, the tab order is changed shown below.
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.
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.
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.
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.
Are you new to Azure Data Factory and wondering what you don't know you don't know? The learning curve with new technologies can sometimes lead to some major refactoring down the line once we realize our mistakes. Join Meagan Longoria and Kerry Tyler to learn how to set up your data factory for success. They will start by discussing naming conventions, parameterization, Key Vault usage, and deployment with Azure DevOps. Then they'll share their recommendations on pipeline hierarchies, activity dependencies, error handling, and monitoring. Watch this webinar to help your organization avoid Data Factory regrets!
Watch Denny and Joey from DCAC, and Rob Krug from Avast as they talk about enterprise security, where companies fail from a security perspective, and what small / medium companies can do to get enterprise-grade security features without breaking the bank.
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.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.