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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

The custom connector itself may not be the culprit.  How are you handing the parameters over to the connector?

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