locked
How to search for fields RRS feed

  • Question

  • Hello. I have 10 tables and TONS of fields. Is there an easy way to search for a field name to quickly insert into pivot table? gracas 
    Wednesday, August 10, 2016 5:53 PM

Answers

  • Hi Alex,

    In your scenario, there are so many fields in your PowerPivot data model, it's hard for your to find a field quickly, so you can find a field easily, right?

    Based on my research, there is no such a search feature in current version of PowerPivot. If you have any concerns about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product.

    Thank you for your understanding.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by AlexMartini Friday, August 19, 2016 10:55 PM
    Sunday, August 14, 2016 8:23 AM

All replies

  • Hi Alex,

    In your scenario, there are so many fields in your PowerPivot data model, it's hard for your to find a field quickly, so you can find a field easily, right?

    Based on my research, there is no such a search feature in current version of PowerPivot. If you have any concerns about this feature, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product.

    Thank you for your understanding.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by AlexMartini Friday, August 19, 2016 10:55 PM
    Sunday, August 14, 2016 8:23 AM
  • Yeah, exactly that. I have like 60 fields/measures in each table or more. 
    Friday, August 19, 2016 10:55 PM