This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
This month we have an exciting on-premises data gateway release! We've made several improvements, from re-designing the summary page for the gateway, to adding new functionality to make it easier to connect to the gateway in your environment as well as to troubleshoot issues you might run into
Here’s the list of features we’re shipping today:
Here is a quick tour on what the new UI will show:
Staring this release, you can use the gateway's UI to change the Windows user's account the gateway is running under. By default, the gateway will be running under "NT SERVICE\PBIEgwService", you can change this by clicking on "change account" which will ask you for the Windows account credentials you'd like to use to run the gateway under. Changing the Windows account will take you through the gateway configuration page, so if you’d like to keep using the same gateway you've stared from, make sure you remember the Recovery Key before you proceed.
Changing the Windows account will kick off the gateway configuration experience, so you need to sign in with the PBI service account again and choose "Migrate or Restore and existing gateway" to restore the previous gateway. Once you've restored the gateway, you will have your existing gateway, with the gateway service running under the new Windows Account.
Often times you need to do this if you have a locked-down environment and only local domain accounts can configure the gateway.
You can enable additional logging to output queries and their timings. Make sure to switch it back to off once you've completed the investigation as leaving this on may impact your gateway's performance.
Remember to click Apply and restart the gateway so this change takes effect.
This will export all your gateway logs into a single .zip file to make it easier to share.
You can force the gateway to communicate with Azure Service Bus using HTTPS instead of direct TCP, or switch back to TCP.
You need to remember to click Apply here and restart the gateway so this change takes effect.
This will check whether the gateway can access the outside network. You can check this at any time.
To activate, simply open the latest gateway release, go to Network: “Azure Service Bus connectivity mode”, switch the toggle to on, and finally click Apply to restart the gateway Windows service. Once it's restarted, this change will take place and there will be no network communication using direct IP addresses.
In addition to the updated checks, the error messages have been refined to be more actionable and help users understand what specifically failed during the network connectivity check, for example: "Gateway can't access the Azure Service Bus endpoint", versus "the gateway can't access anything outside the network".
That’s all for this month, we hope you enjoy these new features and continue sending us your feedback.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.