Forum Discussion
The remote server returned an error: (500) Internal Server Error
Hi Anonymous ,
We found the solution to our issue, all permissions appeared to be ok but it only works with intune admins. This was because "All unlicensed admins have access to Intune" which you can verify in Intune under "Tenant administration / Roles / Administrator licensing".
Assigning an "Enterprise Mobility + Security E3" license to the user account solved the issue. Which has the Microsoft Intune Plan 1
Hi Joyce Anonymous ,
Thank you for your reply.
Does selecting any table in the navigator give the same error?
- Yes, I can see the list of tables but selecting any table will result in the error message.
Could other administrators connect successfully?
- I have an administrator who can see the data, but we can't determine the differences. We also tried different permissions in Intune.
Also, please connect intune data at a different timeline to check if this is a temporary issue.
- I'm not sure what you mean by a different timeline
Lastly, make sure you are using the latest power bi desktop.
- I'm using version: 2.131.1203.0 64-bit (July 2024)
The same error occurs when creating the connection in Excel.
Hi Bswuste ,
Thank you for your feedback.
As you said, another admin could access the data right?
Make sure the user must be one of:
- Microsoft Entra Global Administrator
- An Intune service administrator
- User with role-based access to Intune data warehouse resource
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.