DataSource.TestConnection is a Power Query M function that tests if a connection to a data source can be established and credentials are valid, returning true or an error.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
DataSource.TestConnection( dataSource as any ) as logicalDescription
Returns true if a connection to dataSource‘s data source can be established or an error otherwise.
Will not run or demand permissions for user native queries when dataSource is a direct data source function invocation.
In general, checks the connection of a table, record, list, or binary value by reading the first value.
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy