topic Re: survey 123 and Power BI in ArcGIS for Power BI Questions https://community.esri.com/t5/arcgis-for-power-bi-questions/survey-123-and-power-bi/m-p/764060#M45 <HTML><HEAD></HEAD><BODY><P>Upvote this idea <A _jive_internal="true" href="https://community.esri.com/ideas/13853-arcgis-data-connection-for-power-bi">https://community.esri.com/ideas/13853-arcgis-data-connection-for-power-bi</A>. In that idea is a user comment that suggests a&nbsp;workaround. If your form is simple enough (no repeats or attachments) and if you are good at JSON transformation using DAX and PQE, it should be easy enough.</P><P></P><P>As to using the feature layer of the Survey123, you got to pay attention to your form's schema. Working for my previous employer, I created a complex S123 form that fed the data daily into a PBI report. Between S123 and PBI, I used an ETL tool (FME Desktop) that stored the form data into SQL Server. If you have access to ArcGIS Pro you can use its DataInterop extension to do the same. You have options.</P></BODY></HTML> Fri, 17 Jan 2020 14:47:13 GMT RenatoSalvaleon3 2020-01-17T14:47:13Z survey 123 and Power BI https://community.esri.com/t5/arcgis-for-power-bi-questions/survey-123-and-power-bi/m-p/764059#M44 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P>Has anyone tried to visualize Survey 123 form (tabular) data form the hosted feature service in Power BI? It sounds like the functionality is not there yet to directly view a feature layer's attribute table. Has anyone tried a workaround like developing a data export process that runs nightly so the tabular data can be displayed in a power BI dashboard? Maybe it's time to try esri Insights?</P><P>Thanks,</P><P>Renee</P></BODY></HTML> Fri, 16 Aug 2019 15:33:02 GMT https://community.esri.com/t5/arcgis-for-power-bi-questions/survey-123-and-power-bi/m-p/764059#M44 ReneeOpatz 2019-08-16T15:33:02Z Re: survey 123 and Power BI https://community.esri.com/t5/arcgis-for-power-bi-questions/survey-123-and-power-bi/m-p/764060#M45 <HTML><HEAD></HEAD><BODY><P>Upvote this idea <A _jive_internal="true" href="https://community.esri.com/ideas/13853-arcgis-data-connection-for-power-bi">https://community.esri.com/ideas/13853-arcgis-data-connection-for-power-bi</A>. In that idea is a user comment that suggests a&nbsp;workaround. If your form is simple enough (no repeats or attachments) and if you are good at JSON transformation using DAX and PQE, it should be easy enough.</P><P></P><P>As to using the feature layer of the Survey123, you got to pay attention to your form's schema. Working for my previous employer, I created a complex S123 form that fed the data daily into a PBI report. Between S123 and PBI, I used an ETL tool (FME Desktop) that stored the form data into SQL Server. If you have access to ArcGIS Pro you can use its DataInterop extension to do the same. You have options.</P></BODY></HTML> Fri, 17 Jan 2020 14:47:13 GMT https://community.esri.com/t5/arcgis-for-power-bi-questions/survey-123-and-power-bi/m-p/764060#M45 RenatoSalvaleon3 2020-01-17T14:47:13Z