Tag Archives: onpremises
Microsoft Dynamics 365 (on-premises) Update 2.15
Choose your path
Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today’s Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Microsoft Dynamics 365 (on-premises) Update 2.14
INTRODUCTION
Service Update 2.14 for Microsoft Dynamics CRM (on-premises) 8.2 is now available. This article describes the hotfixes and updates that are included in Service Update 2.14.
MORE INFORMATION
| Update package | Version number |
|---|---|
| Microsoft Dynamics 365 (on premises) Update 2.14 | 8.2.14.10 |
To determine whether your organization had this update applied, check your Microsoft Dynamics CRM Online version number. Click the gear icon in the upper-right corner, and then click About.
Update information
Microsoft Dynamics 365 (on-premises) Update 2.14 is now available.
The following file is available for download from the Microsoft Download Center:
Download the Microsoft Dynamics 365 (online and on-premises) Update 2.14 package now.
Microsoft Dynamics 365 (on premises) Update 2.14 resolves the following issue:
Repaired Functionality
The following list details issues whose resolutions repair items in Dynamics that are not functioning.
Platform Services
- Importing a database with version 8.1.1.1005 to Dynamics 365 version 8.2.5.4 failed.
Sales
- When changing the name of a “Product” column and then selecting “Preview”, the Preview window appeared and then crashed.*
Unified Interface
- Users assigned the Salesperson role could not capture and log into Dynamics 365.*
To see the entire list of available updates follow this link: Microsoft Dynamics CRM / Dynamics 365 Updates: Release Dates, Build Numbers, and Collateral
Walter Carlin
Senior Premier Field Engineer | Dynamics 365 CE | Microsoft Corp.
On-premises data gateway December 2019 update is now available
We are happy to announce that we have just released the December update for the On-premises data gateway (version 3000.21.18)
- December Version of the mashup engine
- GA of Kerberos based Single Sign-On (SSO) for
- SAP BW Message Server
- Oracle
GA of Kerberos based Single Sign-On (SSO) for SAP BW Message Server and Oracle
You have been able to use Single Sign-On, leveraging Kerberos, when connecting to some data sources including SAP BW Application Server in DirectQuery mode from Power BI. You can now also connect to SAP BW Message server using Single Sign-On leveraging Kerberos.
Once you install the latest gateway, browse to the manage gateways page. Select the intended gateway and click on “Add data source”. When you select SAP BW Message Server data source type, you should see the SSO for Kerberos option(highlighted below) now.
Similarly we have also enabled SSO leveraging Kerberos for Oracle also.
December version of the mashup engine
This month’s Gateway update also includes an updated version of the Mashup Engine, which will match the one released as part of the Power BI Desktop December update This will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/runtime as in the latest Power BI Desktop version.
Please continue to send us feedback for what new capabilities you’d like to see in the future.
Microsoft Dynamics 365 (on-premises) Update 2.13
Choose your path
Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today’s Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
On-premises data gateway November 2019 update is now available
We are happy to announce that we have just released the November update for the On-premises data gateway (version 3000.14.39)
Here are some of the key things that we would like to highlight with this month’s release:
- Change a gateway’s recovery key
- November version of the mashup engine
Change Gateway Recovery Key
The recovery key provided by gateway admins during installation of gateways cannot be changed today This key is used to create the symmetric key which in turn is used for encrypting credentials in data sources/connections using that gateway.
With the November release of Data Gateways, you will now be able to rotate this key. More information about recovery keys, detailed description on how to perform this change and associated limitations can be found in the data gateway docs.
November version of the mashup engine
This month’s Gateway update also includes an updated version of the Mashup Engine, which will match the one released as part of the Power BI Desktop update this month. This will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/runtime as in the latest Power BI Desktop version.
Please continue to send us feedback for what new capabilities you’d like to see in the future.
Microsoft Dynamics 365 (on-premises) Update 2.12
Choose your path
Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today’s Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
On-premises Data Gateway management by Region
We are happy to announce that we have made enhancements to gateway management operations on Power Platform Admin center. We have added new features listed below:
- Manage Gateways by Regions
- Share Gateways
- Get Help
Manage gateways by Region
In the past, only gateways within your tenant’s default region were visible on the admin center. Now we are also making management of gateways in other regions possible.
Select the region dropdown to see the list of gateway regions. When you select one of the regions, you will see the list of gateways installed in that region. You can now manage users or view gateway members for these gateways.
Additionally, we have also updated our new PowerShell cmdlets in Public Preview to include region specific cmdlets. Do provide any feedback so we can continue to improve these.
Share Gateways
Earlier this year, we enabled managing administrators for gateways from the power platform admin center. You can now share gateways as Admin, “Can Use” or “Can use + share”.
Note: “Can Use” or “Can use + share”, however applies only to PowerApps and Microsoft Flow.
Get Help
If you run into issues while managing gateways on the Power Platform Admin center, you could create a support ticket with Microsoft. While doing so, please include the session id shown below. This would help us troubleshoot the issue faster.
Please continue to send us feedback for what new capabilities you’d like to see in the future.
On-premises data gateway October 2019 update is now available
We are happy to announce that we have just released the October update for the On-premises data gateway (version 3000.10.232).
Here are some of the things that we would like to highlight with this month’s release:
- Public Preview of Kerberos based Single Sign-On (SSO) for
- SAP BW Message Server
- Oracle
- Skip test connection for Web or OData
- October Version of the mashup engine
- Performance Monitoring Improvements
- Improved Gateway Documentation
Kerberos based Single Sign-On (SSO) for SAP BW Message Server and Oracle (Public Preview)
You have been able to use Single Sign-On, leveraging Kerberos, when connecting to some data sources including SAP BW Application Server in DirectQuery mode from Power BI. You can now also connect to SAP BW Message server using Single Sign-On leveraging Kerberos.
Once you install the latest gateway, browse to the manage gateways page. Select the intended gateway and click on “Add data source”. When you select SAP BW Message Server data source type, you should see the SSO for Kerberos option(highlighted below) now.
Similarly we have also enabled SSO leveraging Kerberos for Oracle also.
Skip test connection for Web or OData
Skip test connection was enabled for On-premises Power BI data sources in April. We are happy to announce that we have enabled Skip test connection feature for Web and OData data sources now.
Performance Monitoring Improvements
Based on your feedback, we have now included an additional file called the Query start Report containing the Query start time and also the actual query text. You no longer need to turn on additional logging to obtain the query text. The Query start report contains the following attributes:
| Attribute | Description |
| GatewayObjectId | Unique identifier for the gateway. |
| RequestId | Unique identifier for a gateway request. It could be the same for multiple queries. |
| DataSource | Contains both the data source type and data source. |
| QueryTrackingId | Unique identifier for a query. |
| QueryExecutionStartTimeUTC | Time when the query execution started. |
| QueryType | Type of query. For instance, the query passed could be a Power BI refresh or DirectQuery. Or, it could be queries from PowerApps and Microsoft Flow. |
| QueryText | Complete query. |
In addition to the new report file, we have also updated the Performance monitoring template in this release. The new version includes not only the new Query text and start time but also new visuals to improve the overall troubleshooting experience.
Improved Gateway Documentation
We have heard your feedback and re-written the gateway documentation. We split them it into content that’s specific to Power BI and general content that applies to all services that the gateway supports. To provide feedback on each article, or the overall gateway docs experience, scroll to the bottom of any article.
October version of the mashup engine
This month’s Gateway update also includes an updated version of the Mashup Engine, which will match the one released as part of the Power BI Desktop October update This will ensure that the reports that you publish to the Power BI Service and refresh via the Gateway will go through the same query execution logic/runtime as in the latest Power BI Desktop version.
Please continue to send us feedback for what new capabilities you’d like to see in the future.
On-premises data gateway management via PowerShell (Public Preview)
We are happy to announce the public preview of a new set of PowerShell cmdlets which will enable automation of gateway management tasks. Please review the online documentation for additional details.
These PowerShell scripts help manage
- On-premises data gateways
- Power BI Data sources
Note: These cmdlets require PowerShell core 6.2.2 or higher
The cmdlets are available on PowerShell Gallery and can be installed in an elevated PowerShell session:
Install-Module -Name DataGateway
Examples and descriptions are included in the cmdlets and you can access them using:
get-help <cmdlet-name>
Following are PowerShell cmdlets which can be used for administering gateway clusters and members:
- Get-DataGatewayCluster: Lists all gateway clusters for the current user or a specific one based on the passed parameters
- Get-DataGatewayClusterStatus: Returns the cluster status along with additional properties
- Get-DataGatewayInstaller: Lists users authorized to install and register gateways within the tenant
- Get-DataGatewayTenantPolicy: Returns the gateway installation and registration policy for the tenant.
- Add-DataGatewayClusterUser: Add a specific user to a gateway cluster for specific permissions
- Set-DataGatewayCluster: Set properties of an existing gateway cluster
- Set-DataGatewayInstaller: Modify list of users who can install and register new gateways on the tenant
- Set-DataGatewayTenantPolicy: Set the gateway installation and registration policy for the tenant
- Remove-DataGatewayCluster: Remove a gateway cluster
- Remove-DataGatewayClusterMember: Remove a gateway member from the corresponding gateway cluster
- Remove-DataGatewayClusterUser: Remove a user from a gateway cluster
In addition, wherever applicable, these cmdlets can be run under a tenant level scope. This would of course require the user to be a global Office 365 admin or a Power BI service admin. For instance, the following cmdlet would return all gateways within your tenant.
Get-DataGatewayCluster -Scope Organization
Similarly, running the same command without the scope parameter or with the “Individual” scope would return the list of gateways, you are administrator of.
Get-DataGatewayCluster -Scope Individual
Another new cmdlet, which allows tenant admins to restrict installation of on-premises data gateway ins standard mode is as follows. The tenant admin can then allow specific users to install using the Set-DataGatewayInstaller cmdlet.
Set-DataGatewayTenantPolicy -ResourceGatewayInstallPolicy Restricted
Following are PowerShell cmdlets which can be used for managing Power BI data sources:
- Add-DataGatewayClusterDatasourceUser: Add a user with required permissions for a Power BI data source
- Get-DataGatewayClusterDatasource: Lists all Power BI data sources on a gateway cluster or a specific one based on the passed parameters
- Get-DataGatewayClusterDatasourceStatus: Returns the connectivity status of a data source in a gateway cluster
- Get-DataGatewayClusterDatasourceUser: Lists users who have access to the specific Power BI data source in a gateway cluster
- Remove-DataGatewayClusterDatasource: Removes a Power BI data source from a gateway cluster
- Remove-DataGatewayClusterDatasourceUser: Removes a user from a Power BI data source
- Set-DataGatewayClusterDatasource: Set properties of an existing Power BI data source
We will be enriching these cmdlets with additional management operations in the upcoming releases.
Please continue to send us feedback for what new capabilities you’d like to see in the future.
Microsoft Dynamics 365 v8.2 (on-premises) Update 2.11 – KB4515520
| Update package | Version number |
|---|---|
| Microsoft Dynamics 365 (on premises) Update 8.2.11 | 8.2.11.13 |
To determine whether your organization had this update applied, check your Microsoft Dynamics CRM Online version number. Click the gear icon in the upper-right corner, and then click About.
Update information
Microsoft Dynamics 365 (on-premises) Update 2.11 is now available.
The following file is available for download from the Microsoft Download Center:
Download the Microsoft Dynamics 365 (online and on-premises) Update 2.11 package now.
Microsoft Dynamics 365 (on premises) Update 2.11 resolves the following issue:
Repaired Functionality
The following list details issues whose resolutions repair items in Dynamics that are not functioning.
Platform Services
- When performing a RetrieveMultiple response, the organization context switched intermittently, and the wrong organization’s data was retrieved.