Power BI Connector for Microsoft Excel

Build 24.0.9060

CredentialsLocation

The location of the settings file where MFA credentials are saved.

Data Type

string

Default Value

"EMPTYSTRING"

Remarks

MFA credentials are short-lived and typically expire after an hour. At that point, you must specify a different MFAToken to continue connecting. MFA tokens only work once, so in the case of multi-threaded or multi-process applications, the credentials must be centrally located and shared to avoid problems. When MFAToken is not specified, this property does nothing.

If left unspecified, the default location is "%APPDATA%\\CData\\Excel Data Provider\\CredentialsFile.txt" with %APPDATA% being set to the user's configuration directory:

Platform %APPDATA%
Windows The value of the APPDATA environment variable
Mac ~/.config
Linux ~/.config

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060