Need to connect Power BI with ArcGIS
Budget: $30 – $250 USD
In this project I need you to connect Power BI to ArcGIS Online and make the PBI consume the data from my layers in AGOL or even in my map services (published to my local agol server).
user layers from AGOL as base data in power BI
set up and DESIGN dashboard with simple layout (inspector name, and total inspections)
so better if you are familiar with ArcGis API
we have a feature layer that is on a clients ESRI(arcgis) i want to use that feature layer as the data source for my power BI reports
here I send you a video explaining more about what I need
I want to have power BI connected to 4 arcgis feature layers (possibly include the survey123 inspection data because it is unique data). ensure that all rows and columns included. then add some basic visuals such as cumulative inspections, inspections by inspectors, etc...
did the issues about the token make sense
We are looking for a query that returns all rows and all columns to a feature layer in the arcgis REST api. Should be a pretty standard query I would think. The other issue is that a query will only return the first 2000 rows.
Also in order to make the query you need to add the “token” to the end of the url and that token refreshes periodically. The refreshed token can be retrieved by logging into arcgis and accessing the query/rest api through the feature layer while logged in.
user layers from AGOL as base data in power BI
set up and DESIGN dashboard with simple layout (inspector name, and total inspections)
so better if you are familiar with ArcGis API
we have a feature layer that is on a clients ESRI(arcgis) i want to use that feature layer as the data source for my power BI reports
here I send you a video explaining more about what I need
I want to have power BI connected to 4 arcgis feature layers (possibly include the survey123 inspection data because it is unique data). ensure that all rows and columns included. then add some basic visuals such as cumulative inspections, inspections by inspectors, etc...
did the issues about the token make sense
We are looking for a query that returns all rows and all columns to a feature layer in the arcgis REST api. Should be a pretty standard query I would think. The other issue is that a query will only return the first 2000 rows.
Also in order to make the query you need to add the “token” to the end of the url and that token refreshes periodically. The refreshed token can be retrieved by logging into arcgis and accessing the query/rest api through the feature layer while logged in.