How to load SmartSurvey data through Restful API to Power BI

BILearnerToday — Sun, 17 Jul 2022 12:04:17 GMT

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

Re: How to load SmartSurvey data through Restful API to Power BI

v-chenwuz-msft — Wed, 20 Jul 2022 09:11:49 GMT

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.

topic How to load SmartSurvey data through Restful API to Power BI in Developer

How to load SmartSurvey data through Restful API to Power BI

Re: How to load SmartSurvey data through Restful API to Power BI