Forum Discussion
Solved
How to link Data sources credentials linked dynamically to Power Bi?
Hi, Do you have any suggestions for making Data sources credentials linked dynamically to Power Bi? i.e. instead of hardcoding the Servers and Ports, is there any way to connect through any sing...
You can place these details on a SharePoint and then read them as part of the Power Query steps. However you will get into conflict with the Formula Firewall which exists exactly to prevent things like this.
Sorry, forum only for me.
Alright.
Incase am creating an Sharepoint Excel file, and saving all the credential details like ServerName, Port, UserID, Password, TableName, TableFolder etc. and then passing the values as parameters in Advance Editor.
Will it work? even though I publish the report to Services.
