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