INFO.DATASOURCES DAX Function (Information)

Syntax  |  Return values  |  Remarks  

Represents the TMSCHEMA_DATASOURCES DMV query function.

Syntax

INFO.DATASOURCES ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
RestrictionName	Optional Repeatable	Restriction name.
RestrictionValue	Optional Repeatable	Restriction value.

Return values

Table An entire table or a table with one or more columns.

Field	Type
ID	Integer
ModelID	Integer
Name	String
Description	String
Type	Integer
ConnectionString	String
ImpersonationMode	Integer
Account	String
Password	String
MaxConnections	Integer
Isolation	Integer
Timeout	Integer
Provider	String
ModifiedTime	DateTime
ConnectionDetails	String
Options	String
Credential	String
ContextExpression	String

Remarks

Corresponds to the TMSCHEMA_DATA_SOURCES data management view (DMV).

As all the INFO functions, it cannot be used in calculated tables and calculated columns.

Last update: Nov 14, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.