The JAMF Pro connector beta is experiencing issues with authentication and is unable to authenticate

ashajyothi
New Contributor II

I am attempting to utilize the built-in JAMF Pro connector available as a data source type in Power BI Desktop. I have entered the instance URL and service account credentials, and I am able to view the available tables.

However, when I attempt to select a table, I receive an error message stating "unable to connect to the remote server." I have been informed that the service account has full read access. Should I investigate the roles assigned to the service account in JAMF?

Alternatively, could this connector be known for having reliability issues or being faulty?

3 REPLIES 3

SmithRV2
New Contributor

I had this issue this morning as well. All my Jamf powerbi connections stopped working over the past weekend.

Ended up finding out something had indeed changed on their end.

The solution for me was to ignore the error and go to the transform data area.

1. In PowerBi Desktop press transform data on the dashboard you have connected jamf. 

2. Right-click one of the tables from which the JAMF connecter tried to import data and press "Advanced Editor"

3. Look at the Source line. (usually line 2)
4. Remove the forward slash at the end of the source. delete space and press ok.

Example: 
Original: Source = JamfPro.Contents("https://example.jamfcloud.com/"),

Fixed: Source = JamfPro.Contents("https://example.jamfcloud.com"),

5. Data loaded fine after that. Really strange but that seemed to fix the issue. 

 

Hopefully this helps. Loved all the refresh errors I received over the weekend. 

 

 

 

ashajyothi
New Contributor II

Hello @SmithRV2 ,

The above provided information really helpful

Thanks for the link, Original: Source = JamfPro.Contents("https://example.jamfcloud.com/"),

ashajyothi
New Contributor II

You can also try to log in using your own user ID and password to determine if you are authorised user

MYBKExperience