Forum Discussion

RyanGilreath's avatar
RyanGilreath
Regular Visitor
4 years ago

Customer Voice - Context Data

Hello,

 

We have a survey that is sent to a list of customers which includes several Personalization Variables, including the specific location within a client account where that person works.

The surveys are sent via a PowerAutomate flow which looks at a Sharepoint list and sends monthly.

When viewing the response in Dataverse, the Context data is available but I cannot for the life of me understand how to expose those values to PowerBI.

 

Can anyone point me to a resource on where the Context Data is stored and how I can get those values for each response in PowerBI?

 

In the MS Documentation, there appears to be a table called "msfp_embeddedcontextparamaters" but that table does not exist in our environment (https://docs.microsoft.com/en-us/dynamics365/customer-voice/developer/entities/msfp_surveyresponse#BKMK_msfp_embedcontextparameters)

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi RyanGilreath 

    Thanks for reaching out to us. 

    Do you mean you can view the response in Microsoft Dataverse, then you want to get these response in Power BI Desktop? If so, you can use Dataverse connector in Desktop, then search the related content in Preview Pane,

    For more details, please read this article, https://docs.microsoft.com/en-us/power-query/connectors/dataverse

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.