Custom Connector VS and PBI Desktop Inconsistency

[Anonymous]

I've been trying to create a custom connector for a REST API for the first time and appear to be getting some inconsistancies between the Visual Studio output and Power BI Desktop itself when using the custom connector. I've slimmed down the full code for simplicity sake.

Custom Connector (excluding the OAuth2 section):

shared TeamworksConnector.Contents = () =>
    let   
        source = ProjectUpdatesTable()
    in
        source;

ProjectUpdatesTable = () as table =>
    let
        projectsUpdates_relPath = "projects/api/v3/projects/updates.json",        
        request = Web.Contents(baseurl, [RelativePath=projectsUpdates_relPath]),
        json = Json.Document(request),
        projectUpdates = json[projectUpdates],
        #"Converted to Table" = Table.FromList(projectUpdates, Splitter.SplitByNothing(), null, null, ExtraValues.Error)   
    in
        #"Converted to Table";

When executing the following in Visual Studio it returns nothing, however, when using the connector in Power BI desktop it does return the expected result. I've inspected the connector to ensure it is indeed the same version. This is also hindering the ability to refresh in the service via the gateway. The error persists from VS PowerQuery SDK to the Power BI service but not Power BI desktop itself.

I also output various other tables in the Nav table for different endpoints which utilise the same logic and follow the same response structure, these work perfectly fine In both VS and PBI Desktop.

Picture of the output within the Nav Table utilising the exact same custom connector which is failing in VS:

Not sure where to look next, any suggestions?

[Anonymous]

Hi @Anonymous ,

I'm sorry I'm not quite sure what your problem is? Does it mean that custom connector works fine in VS and Power BI Desktop, but not in service and thus cannot be refreshed? Is there any error message? Could you please provide me with a screenshot of the error? Thank you.

In addition, please review the content in the following links about configure schedule refresh for custom connector. Hope they can help you.

Microsoft Power BI Data Connector

How to enable scheduled refresh for your custom connector

Best Regards