Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 months ago
Solved

Navigator Issue - Total Newbie

Hi All,   I'm a total newb with Power BI and using APIs in general, so please have patience with me!   I'm attempting to use Power BI to connect to a specialized ERP system to build a report.  Th...
Need Help
  • Anonymous's avatar
    Anonymous
    7 months ago

    I found the issue!  On the vendor's website listing the various API endpoint URI's, they left off the trailing / character.  I was simply cutting and pasting the link into Power BI, which was enough to load the navigator menu but it failed when trying to retrieve data.  

    When I included the trailing slash character, the data preview loaded.  My next challenge is to figure out why the "Load" and "Transform Data" buttons don't activate, but for now I've made progress!

Amar_Kumar's avatar
Amar_Kumar
Super User
7 months ago

Anonymous 

You cannot force Power BI to use a different URI inside Navigator.

What is happening:

  • Power BI connects correctly using the base URI

  • The ERP connector builds table URLs internally

  • When you click a table, the connector generates a wrong endpoint

  • Power BI just executes it and gets a 404

Where the issue is:

  • The ERP vendor’s Power BI connector

  • Incorrect URL construction or API metadata

  • Not a Power BI bug

What you can do:

  • Check the Source step in Power Query (Advanced Editor)

  • If the connector code is locked, you cannot fix it

  • Ask the vendor to fix their connector

  • As a workaround, use the Web connector and call the API manually

Note: Power BI cannot override Navigator URLs. The problem is in the ERP connector/API implementation.