Set-AXReportDataSource

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Set-AXReportDataSource

Modifies the data source connection string and provider to use for Microsoft SQL Server Reporting Services reports.

Syntax

Parameter Set: Default
Set-AXReportDataSource -DataSourceName <String> [-ConnectionString <String> ] [-Provider <String> ] [-ServicesAOSName <String> ] [-ServicesAOSWSDLPort <Int32> ] [-ServicesFilePath <String> ] [ <CommonParameters>]

Detailed description

The Set-AXReportDataSource cmdlet modifies the data source connection string and provider to use for Reporting Services reports.

Parameters

-ConnectionString<String>

Specifies the new connection string to use for the data source.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-DataSourceName<String>

Specifies the name of the data source to be modified.

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Provider<String>

Specifies the new provider to use for the data source.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ServicesAOSName<String>

Specifies the name of a Microsoft Dynamics AX Application Object Server (AOS) instance to connect to instead of the default value.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ServicesAOSWSDLPort<Int32>

Specifies the web service (WSDL) port of an AOS instance to connect to instead of the default value.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ServicesFilePath<String>

Specifies a client configuration parameter file (.axc) to use instead of the configuration that is stored in the registry.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, OutBuffer, OutVariable, WarningAction, and WarningVariable. For more information, see about_CommonParameters https://go.microsoft.com/fwlink/?LinkID=113216

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None

    You cannot pipe input to this cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

  • See below.

    The cmdlet does not generate any output.

Examples

This example creates a SQL Server data connection string and provider for Microsoft Dynamics AX to use for SQL Server Reporting Services reports.

C:\PS>Set-AXReportDataSource -ConnectionString "Server=.\INSTANCE01;Database=AXDBDEV;Trusted_Connection=True" -DataSourceName DataSource01 -Provider SQL -ServicesAOSName AOS01

Update the OLAP data source

Get-AXReportDataSource

Copyright Microsoft Corporation. All rights reserved.