May 9, 2024
Hi, thanks for reading.
I've not written about it yet but I'll try to find the time in the next days anyway I'll try to summarize the idea.
- build an array that contains all the workspaces you need to loop (Power BI APIs can help you here)
- for each workspace call an api that gives the list of the semantic models in that workspace
- for each workspace use tabular command line to connect to that semantic model and run the script that I wrote
you can do this in PowerShell
I suggest to create an Azure App to login to avoid credentials request for each workspace.