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 ?