Forum Discussion
Easy Way to Delete Columns Not in Use
Hello All,
I have an Azure SQL database that I pull into my reports. It's quite large so I like to go through and delete columns not getting used in a report to help speed up the response and refresh times. I have been going through and doing this manually. My question, is there a way to do this easier or for the system to somehow tell me what columns arent being accessd so I can then delete them?
Thank you
6 Replies
- gpiero
Skilled Sharer
Anonymous
here an option
in the Navigation step you can select what import or not in Choose Column
Regards
- gpiero
Anonymous
Hi,
it is very likey I am wrong but I believe that during the data modelling and shaping, we should decide what I need or not in my report.
For istance, data modeling from a Sharepoint online Custom List, include so many columns not relevant for the pbix, since they belong to SPO environement.
At that stage I have to decide what select or not and I am quite sure that we do not have any tools that later shows which columns has been used or not.
Unless you open tha Navigation stage and check one by one.
Regards
XLBobResolver II
give Power BI helper a try, it will give u a list of columns that are used in your Power BI report. Although it's not giving you an exhaust list but it's a good starting point.
https://radacad.com/power-bi-helper
