Retrieve Columns and their descriptions from multiple semantic models

Hi Anonymous ,

Thanks for reaching out to our community.

According to my understanding, you are seeking a solution to compile data dictionaries for multiple datasets into a single report. 

To achieve this, you can try using List.Generate() to iterate through a list of datasets and compile the data dictionary for each. 

For example,

//Use List.Generate to iterate through the list of datasets and get column details 
ColumnDetailsList = List.Generate(
        () => [Index = 0, Result = GetColumnDetails(DatasetList{0}[WorkspaceName], DatasetList{0}[DatasetName])],
        each [Index] < List.Count(DatasetList),
        each [Index = [Index] + 1, Result = GetColumnDetails(DatasetList{[Index]}[WorkspaceName], DatasetList{[Index]}[DatasetName])],
        each [Result]
    ),

If you want to learn more about it, please refer to 

List.Generate() and Looping in PowerQuery - Exceed

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.