cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FrankT Frequent Visitor
Frequent Visitor

API - Default.GetBoundGatewayDataSources

For some of my datasets the Get Bound Gateway Datasources operation will fail because the field 'isOnPremGatewayRequired' of the record wasn't found. At first sight this seems to be a bug!?

 

 [DataSource.Kind="PowerBIRESTAPI"]
 PowerBIRESTAPI.BoundGatewayDataSources = () =>
let
    source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/datasets")),
    value = Table.FromRecords(source[value]),
 selected = Table.SelectColumns(value, {"id", "name"}),
    BoundGatewayDataSources = Table.AddColumn(selected, "Call", each try Json.Document(Web.Contents( "https://api.powerbi.com/v1.0/myorg/datasets/" & [id]&"/Default.GetBoundGatewayDataSources", [
      Headers = [
                #"Content-type" = "application/json"
            ]])) otherwise null)
in
    BoundGatewayDataSources;
 

Screenshot.JPG

 

Expression.Error: The field 'isOnPremGatewayRequired' of the record wasn't found.
Details:
    id=25ec7826-1da2-4799-9dff-db84983ef86d
    name=RealTime
    addRowsAPIEnabled=TRUE
    configuredBy=XXXXXXXXXXXXX
    isRefreshable=TRUE
    isEffectiveIdentityRequired=FALSE
    isEffectiveIdentityRolesRequired=FALSE
 
Expression.Error: The field 'isOnPremGatewayRequired' of the record wasn't found.
Details:
    id=7ea173b5-1813-4bd9-9def-b40ecf89d0a3
    name=Report Usage Metrics Model
    addRowsAPIEnabled=FALSE
    configuredBy=XXXXXXXXXXXXX
    isRefreshable=FALSE
    isEffectiveIdentityRequired=FALSE
    isEffectiveIdentityRolesRequired=FALSE

 

The affected records seem to be either realtime or usage metrics or workbooks (Excel Services).

 

Indeed these records do not have the field isOnPremGatewayRequired.

 

screenshot2.JPG

 

Any ideas?

3 REPLIES 3
Microsoft v-jiascu-msft
Microsoft

Re: API - Default.GetBoundGatewayDataSources

Hi @FrankT,

 

What data did you expect from this operation? Why not deleting the errors?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FrankT Frequent Visitor
Frequent Visitor

Re: API - Default.GetBoundGatewayDataSources

Naturally, I expect the API to give me the record fields available for each dataset. I do not ask for the missing field.

Furthermore, an error is returned despite " try ... otherwise"

klinejordan Frequent Visitor
Frequent Visitor

Re: API - Default.GetBoundGatewayDataSources

Searching for help on this very topic - have you identified a workaround?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors