This one is a second post related to: Some basic ArcGIS queries! - Esri Community
(Note: This is now more of a how to / reference, as I have now solved it - I was missing a second expand in transformation!)
I am now trying to access the data in the feature layer, to use in the visualisation.
I can access, and 'see' the data in BI, but not in a format that lets me see separate fields. I suspect I am transforming it incorrectly.
Here is a walkthrough of where I am up to:
My source is: NHS Integrated Care Systems and Sustainability and Transformation Partnership areas - Overview (arcg... , and I am using the following services URL: https://services-eu1.arcgis.com/HmXX14BUtsRH0WH5/arcgis/rest/services/GBR_BND_ICSSTP_BritishRC_20210...
Using this guide: How to use ArcGIS with Power BI - Resource Centre | Esri UK & Ireland I am adding the following suffix (/query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json) to add to the above to create the web query (https://services-eu1.arcgis.com/HmXX14BUtsRH0WH5/arcgis/rest/services/GBR_BND_ICSSTP_BritishRC_20210...).
I then set delimiter to TAB (as I only want one column!) and go through the steps of transforming to JSON, Drilling into Features, Expanding and de-selecting the prefix for the column.
I was originally posting with an issue of just having one 'attributes' data point.
However, the key is to expand twice - i.e. hit the button again to expand the attributes! (the eventual result can be seen in the attached Image.
I am still hunting to answers from the previous questions however 🙂