Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Aks8093
Frequent Visitor

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 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?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

15 REPLIES 15
v-tianyich-msft
Community Support
Community Support

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.

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

lbendlin
Super User
Super User

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.

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

Any error message?

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.

Can you show a sanitized version of the query?

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

It'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.

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.

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.

Understood your point. Thanks a lot.

just for test

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.