Forum Discussion

Sania198's avatar
Sania198
Frequent Visitor
3 years ago
Solved

How to Pull Parameters (Server & Database) programmatically from SQL Database via PowerShell Script

Hi, I can successfully update the parameters using: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters-in-group , however I need help in updating Parameters (Server & Dat...
  • Sania198's avatar
    Sania198
    3 years ago

    I resolved the issue! ðŸ™‚

    Need to pass If condition in between Foreach loop to get the specific details and to update it to the dataset.

    Thanks for your responses lbendlin 

Sania198's avatar
Sania198
Frequent Visitor
3 years ago

lbendlin 

I am ready to modify the script if needed, can you please help me with sample script

1. I have a SQL DB table with Server and Database details for different clients
For example, we have A,B,C,D as clients name

2. I want to use that SQL query and pull those parameters (Server and Database) details of specific client of "C" 

3. Then it should update to the Power BI dataset I specify

 

That's my requirement 

Sania198's avatar
Sania198
Frequent Visitor
3 years ago

I resolved the issue! ðŸ™‚

Need to pass If condition in between Foreach loop to get the specific details and to update it to the dataset.

Thanks for your responses lbendlin