load arcgis online data into Power BI using OAuth2.0 or token

[gdaniel21]

I can load the map but the attribute table shows error

[amitchandak · Accepted solution]

@gdaniel21 , check Power BI semantic model settings on the service and see if it asks for login for various connections needed 

[v-dineshya · Accepted solution]

Hi @gdaniel21 ,

Thank you for reaching out to the Microsoft Community Forum.

Use the Esri ArcGIS visual, It is the native supported method.

Please try below steps.

1. Add Esri ArcGIS visual in Power BI Desktop. Sign in using your ArcGIS Online account.

2. Add your map layer.

3. The attribute table will only load if, the layer is a feature layer (not tile layer). You have edit/query permission. Sharing settings allow it (Org/Public).

If the attribute table still fails, Check ArcGIS permissions.

1. The layer must be shared to your organization or everyone.

2. Under Feature Layer --> Settings --> Enable “Allow others to query the data"

3. Ensure it’s not view-only or tile-based.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @gdaniel21 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @gdaniel21 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[amitchandak · Accepted solution]

@gdaniel21 , check Power BI semantic model settings on the service and see if it asks for login for various connections needed