topic Power BI REST API to Get Column Used in Report in Developer

Power BI REST API to Get Column Used in Report

ekimakIA — Fri, 17 Sep 2021 11:04:08 GMT

Hi,

Can you please help us with the REST API through which we can fetch Columns used in the Report? We checked the Dataset and Report API but it didn’t show any results related to Column.

Thank you.

Re: Power BI REST API to Get Column Used in Report

Anonymous — Mon, 20 Sep 2021 06:02:28 GMT

Hi @ekimakIA，

According to my research, I didn't find such a Rest API which can list the column information used in the report. The only Rest API I could find is the below one, and it supports only Push datasets. It will return the information about a dataset, including table names, column names and relationships etc.

Push Datasets - Datasets PostDataset
Also, I found some tools that can help you export the column information used in the report. Hope they can help you.

How to know where field from query is used? (Power BI Helper)

Power BI Field Finder

How to find where a column is used? (VertiPaq Analyzer )

Best Regards

Re: Power BI REST API to Get Column Used in Report

ekimakIA — Tue, 21 Sep 2021 16:01:21 GMT

Hi @Anonymous ,

I tried "Push Datasets - Datasets PostDataset" API and I created Dataset, Tables and Column in PowerBI through this API as shown in below screenshot

But I want to fetch this column details and I tried "Push Datasets - Datasets GetTables" API but in the result i'm only getting table name

Can you please help me with this and let me know like which specific REST API you have tried which gives information about a dataset, including table names, column names and relationships etc?

Thank you

Re: Power BI REST API to Get Column Used in Report

divyavishwakarm — Fri, 21 Jun 2024 12:20:49 GMT

I am facing the same issue, can we know what is the solution here, i need metadata to do a prevalidation but API is not returing anything other then table name