Dynamic Mapping of Semantic Models

Thanks for the reply from GilbertQ.

Hi ReignMaker22 ,

Based on your description of the problem, I'm going to offer an approach:

First we can get all the workspaces by using powershell, the following example will return all workspaces and their names:Get-PowerBIWorkspace (MicrosoftPowerBIMgmt.Workspaces) | Microsoft Learn. 

Store the workspace just acquired and then use the workspace ID to get the semantic model of the corresponding workspace:Get-PowerBIDataset (MicrosoftPowerBIMgmt.Data) | Microsoft Learn. 

At this point we can use the following three APIs to get the details of the semantic model corresponding to the workspace:

Admin - WorkspaceInfo PostWorkspaceInfo - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Admin - WorkspaceInfo GetScanStatus - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn

You need to know enough about powershell commands and API to implement it according to the documentation.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!