Get Column name information of Datasets vs Reports in all workspaces

[SPradeep]

Hi team,

I am trying to get column infromation available in datasets along with respective reports in which they are used. I am kind of wanting to get lineage info of all columns in Power BI service and couldn't get close using options in Rest API or may be I am missing something.

Any leads to get list of columns from datasets and the respctive reports in which they are used will help a lot. Please assist.

Thanks in advance.

Pradeep

[v-yiruan-msft · Accepted solution]

Hi @SPradeep ,

According to my research, I didn't find a elegant way to get the column information related to dataset or report. REST API Datasets - Get Datasets can only get the dataset ID, name, etc., there is no specific column information. In addition, the data lineage view only shows  dependency information among the dataset, the reports referencing the dataset and the applied workspaces. It also does not contain any specific column information. Here's an idea similar to yours to share on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature.

REST API - GET DATASET

Data lineage

Also, you can check out the two blogs below and maybe you will get some other inspiration or idea.

Power BI Field Finder

Power BI Cleanup Tool; Time Saving with Power BI Helper

Best Regards