Forum Discussion
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 😅)
1 Reply
- lbendlinSuper User
Have you tried the standard API calls? Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs