Forum Discussion

TobiasR's avatar
TobiasR
Frequent Visitor
2 years ago

Issue with Custom Connector in Power BI: Unable to Refresh

Hello everyone, I'm facing an issue with Power BI and could use some help. I'm using a custom connector in Power BI, and when I try to refresh for my dataset, I receive the following error ...
Need Help
TobiasR's avatar
TobiasR
Frequent Visitor
2 years ago

Thank you for your suggestion. Here is how I'm currently handling parameters for the custom connector:

When I open the connector, I insert the URL to my data source without any endpoint.

 

Next, I insert a token that I generate from my data source.

 

Once connected, I can choose from different tables.

If I load a table and add some columns to a report, then publish the report and go to the PBI service, I encounter the issue mentioned in my original post.


Please let me know if you need any additional information.


Thanks!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You need to get that token in code, not via the UI.

  • TobiasR's avatar
    TobiasR
    Frequent Visitor
    2 years ago

    I spoke with the developer of the custom connector, and it seems that putting the token in the URL is not possible. Is this required to get it to work?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      That's not what I said. I said you need to acquire the token as part of the Power Query code. You can then present it to the API as part of the payload rather than in the URL

      • TobiasR's avatar
        TobiasR
        Frequent Visitor
        2 years ago

        Hi,

        I'm not sure I fully understand what you mean. Could you please provide an example? Do you need any additional information from me?

        Thank you!