Forum Discussion

Sania198's avatar
Sania198
Frequent Visitor
3 years ago
Solved

How to use SQL query data to create a Power BI Workspaces via PowerShell or Rest API Script

Hi, I want to create a Power BI workspaces by referencing to the view created in our SQL DB. I am successful in pulling the data by connecting to SQL DB where we have a table with DatabaseName, by...
  • lbendlin's avatar
    lbendlin
    3 years ago

    $SQLFile returns an object (the table of the rows for your query result). Now you need to run a ForEach on this to address the individual workspaces.

lbendlin's avatar
lbendlin
Super User
3 years ago

$SQLFile returns an object (the table of the rows for your query result). Now you need to run a ForEach on this to address the individual workspaces.

Sania198's avatar
Sania198
Frequent Visitor
3 years ago

Thanks for the response lbendlin 

If possible, can you please help me with the script to use the ForEach loop for the above ask