How to load SmartSurvey data through Restful API to Power BI

[BILearnerToday]

Hi Everyone,

I have SmartSurvey Dummy Questionnaire published in Smart Survey and I would to view this Dummy data from Power BI.

Smart Survey provides Restful API and I need the GET method, I have created API key and password but when I try to connect to Power BI  I am not sure how to enter all this different information:

I have below infor

1.API KEY

2. API Password

3, Smart Survey HTTP address

4 Smart Survey password

5 Smart Survey Dummy Survey with dummy data

Kindly advise how to pipe Smart Survey Questionnaire  Data to Power BI via API 

If you can provide an example via a screenshot will be very highly appreciated.

Many thanks in advance

[v-chenwuz-msft · Accepted solution]

Hi @BILearnerToday ,

You can try get data from web. Enter headers to the connector.

For more detail, you can refer these links.

How To Get Data From Power BI Dataset Via An API: EPCGroup

Web.Contents - PowerQuery M | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

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