Forum Discussion
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?
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.
15 Replies
- lbendlin
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.
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.
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?
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 ChangIf 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.
