Get title from Azure DevOps 3 leves above

Hi, Jan_DK 

I am glad to help you.   

According to your description, you want to get title from Azure DevOps 3 leves above? 

If I understand you correctly, then you can refer to my solution.  

Since you didn't give me specific datasets to test, I assumed two scenarios myself and created some simple datasets to test, so I hope this helps. 

First scenario: 

First is to assume that ProjectTitle, PBITitle, PBIDescription are located in different tables: 

Then they should have a correspondence and the steps to implement this are as follows: 

After connecting to the data source, select the Projects table in the Power Query Editor and click Merge Queries： 

After this step, click Expand Projects to get ProjectTitle, PBITitle, PBIDescription in the same row in different columns： 

Second scenario: 

Suppose your dataset is in this form: 

Then you need to perform pivot operations, the specific steps are as follows: 

First you need to add the index column: 

Then select Item column and click Pivot Column: 

After this step you can get ProjectTitle, PBITitle, PBIDescription in the same row is located in a different column： 

I hope these suggestions are helpful. If not, please share some data that has the same structure as your dataset. Please note that this data must not contain sensitive or private information. We will do our best to help you solve the problems you are experiencing. 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.