Posted on 11-19-2023 10:45 PM
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?
11-20-2023 10:37 AM - edited 11-20-2023 10:39 AM
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.
Posted on 11-20-2023 10:07 PM
Hello @SmithRV2 ,
The above provided information really helpful
Thanks for the link, Original: Source = JamfPro.Contents("https://example.jamfcloud.com/"),
Posted on 11-21-2023 08:08 PM
You can also try to log in using your own user ID and password to determine if you are authorised user