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

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
Invoke-ASCmd -Server "powerbi://api.powerbi.com/v1.0/myorg/<workspace>" -Database "<dataset>" -Query "select * from `$SYSTEM.TMSCHEMA_PARTITIONS" | Out-File -FilePath c:\users\<user>\Downloads\dmv.xml
  • vk_pbi's avatar
    vk_pbi
    Icon for Resolver II rankResolver II
    3 years ago

    Hi lbendlin 

    I tried your code, but it throws error like System Cube not available. I am accessing this command on Onprem Report server.

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

      Not sure about the syntax there but it should work the same if you properly specify server and cube