Forum Discussion

VinceG0214's avatar
VinceG0214
Frequent Visitor
7 years ago

Custom Data Connector Oauth2

I am trying to build a custom data connector to get our IT ticket information from our ticketing system. Our ticketing system does offer an API that uses Oauth2 and a new refresh token every 60 minut...
Need Help
VinceG0214's avatar
VinceG0214
Frequent Visitor
7 years ago

This connector is now working when I refresh it in Power BI Desktop but will not refresh in the Power BI service online. I am getting an error that says the data source credentials are invalid. When I select "Edit Credentials" and sign in the login windown just refreshes and doesnt do anything. Does anyone have an idea what the issue here is? 

  • Nolock's avatar
    Nolock
    Resident Rockstar
    7 years ago

    Hi VinceG0214,

    as v-juanli-msft said, the code is long, we can't test it and therefore it is complicated to help. But I think I see a problem because I've had a similar one.

    The function GTAConnector.Contents expects an URL but you get a JSON file where the first element is url - you can see it on the screenshot in PBI Service.

    It is described somewhere here: https://docs.microsoft.com/en-us/power-query/samples/trippin/readme but unfortunately I can't find the exact spot right now :(

    Try followings:

    [DataSource.Kind="GTAConnector", Publish="GTAConnector.Publish"]
shared GTAConnector.Contents = (json as text) =>
    let
        source = Web.Contents(json[url])
    in
        source;