How to link Data sources credentials linked dynamically to Power Bi?

[Aks8093]

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 single source to Multiple .pbix files?

Example:- Suppose I have 10 Power Bi reports, incase the Data source server gets changed, I need to change in each and every report individually. Is there any better way to do it?

[v-tianyich-msft]

Hi @Aks8093 ,

If your reports are similar in content, perhaps you might consider using a .pbit file, which will template your reports for use whenever you connect to different data sources.

Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Aks8093]

Thank you for your valuable insight, however this is not what I was looking for.

[lbendlin · Accepted solution]

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.

[Aks8093]

I agree to your point, however post publishing it to services it won't allow to Scheduled refresh. Any suggestions on that?

[lbendlin]

Any error message?

[Aks8093]

As of now 
Formula.Firewall: Query 'DBGrowth' (step 'dbo_DBGrowth') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

[lbendlin]

Can you show a sanitized version of the query?

[Aks8093]

So that means even though I pass the credentials as a parameter, it's not possible to get through the Firewall.

[lbendlin]

It's possible but not advisable. You would have to set all privacy levels to ignore.

[Aks8093]

Could you please share any contact details so as to connect and discuss on the matter?
Thank you.

[lbendlin]

Sorry, forum only for me.

[Aks8093]

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.

[lbendlin]

define "work".  It will "work"  but you need to make extra effort to circumvent the formula firewall. At this point you need to ask yourself if you really want to do that.

[Aks8093]

Understood your point. Thanks a lot.

[JeffreyChen]

just for test