Forum Discussion

samc-powerbi's avatar
samc-powerbi
New Member
2 years ago

Accessing Feature Service Data in PowerBI Using OAUTH - Token Issues

Hello,

 

I am having trouble with tokens generated in my PowerBI query that I've tweaked from the workflow located in this post: https://community.esri.com/t5/arcgis-online-questions/using-excel-to-access-arcgis-online-automated/...

I couldn't find any answers in the linked post to fix my issue - so I've resorted to creating my first post on these forums.

I have recently been getting an error when I try to add additional queries that I am getting an invalid token. This is bizarre as the queries are on the same feature service, just different tables within the feature service.

 

When I switch the client ID and client secret within the query to those of a new application on the Portal, it allows both of the tables within the feature service to be queries - so I am thinking it is an issue with the token being generated from the original client ID and client secret that is expiring.

 

I've included a screenshot of the query with the sensitive information removed - is anyone able to provide some insight on functionality I should/could add to fix the token from expiring? I essentially want to set this up so you just have to replace the relative path in the Get Data section and it will query a new feature service.

 

Thanks in advance!

 

PowerBI Query

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi samc-powerbi ,
    Based on your description, I opened the post you provided and reviewed the procedure, and I noticed that the responder who provided the method mentioned in his reply that the token needs to be constantly refreshed in order to get the attachment. I checked the documentation and posts about ArcgGis according to this direction of investigation, and I did not find any operation that can be performed to refresh the token automatically. In the official documentation about ArcGIS Enterprise, it is mentioned that the solution to Missing token or incorrect login credentials is to start the login ArcGIS to reset the token. So you mentioned that you can query it after re-login, which is the correct solution. Also I noticed that ArcGIS support mentioned using ArcGIS Maps for Office in their reply, you can also try using this to see if it meets your needs.

    ArcGIS Enterprise - Connectors | Microsoft Learn

     

    Best regards,

    Albert He

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly