cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FrankT Advocate I
Advocate I

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
Highlighted
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 Advocate I
Advocate I

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

Re: API - Default.GetBoundGatewayDataSources

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications