Forum Discussion
Connect to Survey123 Data
Hi PBION,
Thanks for reaching out in Microsoft Community Forum.
Thank you rohit1991 for the helpful response.
The "Token Required" error occurs because ArcGIS REST API requires authentication. Please follow below steps to resolve the error;
1. Please Manually create a token from ArcGIS (generateToken API) and append it to the request URL in Power BI.
2. Use Web API authentication in Power Query or set up OAuth2 for automatic token management (recommended for ArcGIS Enterprise).
3. Fetch Survey123 data using Power Automate, store it in OneDrive/SharePoint, and refresh it in Power BI.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hi Rohit,
I have found a resource on the REST services option. I'm currently trying this and using Web as the data source, however I am getting a 'Token Required' error when loading the data. I'm assuming I missed a step in the configuration. Any suggestions?
Hi PBION,
Thanks for reaching out in Microsoft Community Forum.
Thank you rohit1991 for the helpful response.
The "Token Required" error occurs because ArcGIS REST API requires authentication. Please follow below steps to resolve the error;
1. Please Manually create a token from ArcGIS (generateToken API) and append it to the request URL in Power BI.
2. Use Web API authentication in Power Query or set up OAuth2 for automatic token management (recommended for ArcGIS Enterprise).
3. Fetch Survey123 data using Power Automate, store it in OneDrive/SharePoint, and refresh it in Power BI.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.