Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 ref...
data
gpiero's avatar
gpiero
Skilled Sharer
7 years ago

Anonymous 

 

here an option

 

in the Navigation step you can select what import or not in Choose Column

 

Regards

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Oh I didn't know about this feature. It will help but was also looking for a way to see what columns aren't being used in a report. 

  • gpiero's avatar
    gpiero
    Skilled Sharer
    7 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      gpiero 

      A kind of a where used list will surely be beneficial to users, at present manually we need to find the fields that is not in use.