Hi All,
Firstly @lbendlin thank you for your solution!
And @mujibjee , You are trying to implement a query for dynamic input of data credentials, right?
Here's a solution we've found for you, and we hope you find it helpful:
1.Store Credentials in an External File (Excel or Config File):
Create an Excel file or any external configuration file to store the database credentials (e.g., server name, username, password, port).
Format the file as a table with appropriate headers, such as Server, Username, Password, and Port.
2.Use M Code (Power Query) to Fetch and Apply Credentials:
Open the Advanced Editor in Power Query and reference the imported credentials dynamically.
Example:
let
Source = Excel.Workbook(File.Contents("PathToYourExcelFile.xlsx"), null, true),
ConfigTable = Source{[Name="YourTableName"]}[Content],
Credentials = Table.ToRecords(ConfigTable),
ServerName = Credentials{0}[Server],
Username = Credentials{0}[Username],
Password = Credentials{0}[Password],
Port = Credentials{0}[Port],
ConnectionString = "Server=" & ServerName & ";Port=" & Port
in
ConnectionString
3.Dynamic Connection Setup:
Replace hardcoded database connection details with the variables (ServerName, Username, Password, Port) in the connection settings for your data source.
4.Refresh Configuration during Updates:
Power BI will fetch the updated credentials from the external file during every data refresh.
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
