Forum Discussion
How to link Data sources credentials linked dynamically to Power Bi?
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.
So that means even though I pass the credentials as a parameter, it's not possible to get through the Firewall.
Super UserIt's possible but not advisable. You would have to set all privacy levels to ignore.
Could you please share any contact details so as to connect and discuss on the matter?
Thank you.- lbendlin
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.