Forum Discussion

Aks8093's avatar
Aks8093
Frequent Visitor
1 year ago
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...
Interesting Links
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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's avatar
    Aks8093
    Frequent Visitor
    1 year ago

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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

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

      • Aks8093's avatar
        Aks8093
        Frequent Visitor
        1 year ago

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

  • Aks8093's avatar
    Aks8093
    Frequent Visitor
    1 year ago

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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Any error message?

      • Aks8093's avatar
        Aks8093
        Frequent Visitor
        1 year ago

        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.