Skip to content
English
Customer Portal
  • There are no suggestions because the search field is empty.

Power BI Error: "DataFormatError: Extra characters were found at the end of the JSON entry"

If you encounter the error "DataFormatError: Extra characters were found at the end of the JSON entry" while refreshing reports in Power BI, it is typically caused by an authentication issue or an outdated report URL.

 

Troubleshooting Steps:

  1. Re-authenticate with Microsoft

    • Log in to your Microsoft account again.
    • Renew the credentials for all JSON URLs used in Power BI (especially for automatic refresh).

  2. Replace the Report URL

    • In Power BI’s Query Editor, replace the existing report URL with a fresh link copied directly from the Mavim Portal.

  3. Verify the Correct User

    • Ensure Power BI is using the correct user credentials—the same user defined in the Portal for API access.

  4. Test the URL in Postman

    • Use a tool like Postman to test the JSON report URL with Basic Authentication.
    • If the same error appears, it confirms the issue is with the authentication or the URL itself.

© 2025 Mavim. All rights reserved.