Forum Discussion

Clement_lsc's avatar
Clement_lsc
Frequent Visitor
4 years ago

Monitor Sql Server Analysis services connection with parameters through Power Shell

Hello,

 

Since a few days I am confronted to a new problem.

 

I have several reports that are connected to a cube (we use Microsoft SQL Serer Analysis Services) and I need to make their connection configurable. Usually I open Power Query and I create two parameters, one for the server, the other for the database that I implement in the M code. Except that the cube on which I am connected is not supported by Power Query and I cannot create any parameter in Power BI Desktop.

 

So I have to use Power Shell to make the connections configurable. For the moment I can enter my workspace, choose the right dataset to update (its id) but impossible to find how to update its server and datasource in its connection via Power Shell. 
If someone already had this problem and has a script or tracks it would be nice ! Thank you ðŸ˜€

 

Have a nice day ! (I hope it's clear 😅