Forum Discussion

vk_pbi's avatar
vk_pbi
Icon for Resolver II rankResolver II
3 years ago

PowerShell Script to export Database Connection strings in XMLA

Hi there, I am working on a automation project, where i have a requirement to update the connection strings and credentials via powershell. The process flow would likely to be  >Connect SQL Server...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

How is this question related to Power BI?  I assume you are aware of the Power BI REST API?

vk_pbi's avatar
vk_pbi
Icon for Resolver II rankResolver II
3 years ago

Its not directly related.. Yes I am aware of Power BI Rest Api, but it doesn't work with Onprem report server.

So I need to achieve this without using webservice

  • R1k91's avatar
    R1k91
    Icon for Super User rankSuper User
    3 years ago

    If powershell is not a requirement maybe you could think to use Tabular Editor and a combiantion of Advanced Scripting and Command Line interface.

    I've not tested with your usecase but I did something similar in the past: https://medium.com/p/49e8f4a236f9

    • vk_pbi's avatar
      vk_pbi
      Icon for Resolver II rankResolver II
      3 years ago

      Thanks for your suggestion, but currently I can't use Tabular Editor due to some limitations.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Run two DMV queries. 

     

    select * from $SYSTEM.TMSCHEMA_PARTITIONS

    select * from $SYSTEM.TMSCHEMA_EXPRESSIONS

    • vk_pbi's avatar
      vk_pbi
      Icon for Resolver II rankResolver II
      3 years ago

      How can i run these queries ?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        You can run them from any xmla client tool, including Powershell.