Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

can't see salesforce survey objects

We are using the Salesforce Survey tool, It creates standard salesforce objects. These are viewable in the dataloader app from salesforce, as will as various 3rd party tools. Usually you can see all the standard objects in salesforce in the get data, but in powerbi you can't (you also can't in excel or access) I want to stress because it has come up before in questions, these are not custom objects, these are standard salesforce object, they are:

 Survey
Survey Email Branding
Survey Invitation
SurveyInvitationShare
SurveyPage
Survey Question
Survey Question Choice
Survey Question Response
Survey Response
SurveyShare
Survey Version

 

has anyone else run across this problem, is powerbi just not upto date?

 

thanks

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    The salesforce object connector in Power BI Desktop uses salesforce rest api to integrate data with salesforce. However, based on my research, salesforce rest api doesn't provide access to survey objects, but SOAP API provides access.

    Are you able to use salesforce REST explorer  to access the survey object?

    Regards,
    Lydia

  • kymramosrpo's avatar
    kymramosrpo
    Advocate V
    3 years ago

    Hi!
    I am also having this issue. I want to build dataflows with SF Survey objects but I cannot find them. I do see them when using PBi desktop, but not service. Any recent idea on how to deal with this?

  • metrica's avatar
    metrica
    Post Prodigy
    1 month ago

    This may be an API version or permissions issue. Power Query can default to an old Salesforce API version that does not expose the Survey objects. Set a currently supported Salesforce API version, then refresh the object list. Also confirm that Salesforce Surveys or Feedback Management is enabled and that the integration user has access to objects such as Survey, SurveyInvitation, SurveyResponse, and SurveyQuestionResponse.

     

    Power BI Connector for Salesforce by Metrica Software provides another way to select accessible Salesforce objects and fields, preview the output, and use SOQL:
    https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

    It will not bypass Salesforce licensing or permissions, but it can provide a more controlled extraction path.