need to find out all the columns from Power BI report

[froxas]

I need to find out all the colums from DB used in power BI reports.

As  I see i need to go through all reports, through all measures, also M query code in order to find all the columns.

is there another easer way?

[Pragati11 · Accepted solution]

Hi @froxas ,

Check the following blog for the same:

https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper

You can use Power BI Helper to achieve this and it is explained in the above blog.

Thanks,

Pragati

[V-lianl-msft · Accepted solution]

Hi @froxas ,

You can refer to these:

https://community.powerbi.com/t5/Desktop/How-to-find-where-a-column-is-used/td-p/227623 

https://powerbi.tips/2020/01/power-bi-field-finder/ 

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

[Pragati11 · Accepted solution]

Hi @froxas ,

Check the following blog for the same:

https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper

You can use Power BI Helper to achieve this and it is explained in the above blog.

Thanks,

Pragati

[amitchandak]

@froxas , refer if this can help

https://community.powerbi.com/t5/Power-Query/Getting-a-list-of-all-columns-in-all-tables-in-the-data...