Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Quickly Filter Out Salesforce Object Fields

I have recently connected to Salesforce Object, however my opportunity or account object consist alot of fields. Is there a way to quickly filter out the object fields without writing any advance edi...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    In Query Editor of Power BI Desktop, you can use "Choose Column" option to select the columns that you want to reserve.


    Regards,
    Lydia

metrica's avatar
metrica
Icon for Post Prodigy rankPost Prodigy
1 month ago

Choose Columns in Power Query is a good solution if you want to keep only the required fields without writing M code.

 

Another option is Power BI Connector for Salesforce. It lets you select the required Salesforce objects and fields while configuring the data source, before importing the data into Power BI.

 

AppExchange and 30-day free trial: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

Documentation: https://metricasoftware.com/docs/salesforce/

Support and demo: https://metricasoftware.com/docs/salesforce/contact-support/