How to workaround on require Premium to refresh for dynamically fill the "Web. Contents" API?

[Zack92]

Hey there,

I've been grappling with this problem for the past week but haven't found a solution yet. I've tried several different approaches, but none seem to work. I'm attempting to pass the Event ID as a parameter to my API to fill the web contents dynamically. However, I keep running into an error that says, "Computed tables require Premium to refresh. To enable refresh, upgrade this workspace to Premium capacity, or remove this table." It's been quite frustrating, to be honest.

I'm wondering if there's another way I can get around this issue. So far, I've taken the following steps: After creating the parameter, I've tried invoking it on a different table, but that hasn't been successful either. If you have any ideas or suggestions, I would greatly appreciate it.

(eventId as text) =>
let
    BasicURL = "https://api.calendly.com/scheduled_events/",
    RelativePathString = BasicURL & eventId & "/invitees",
    Headers = [Authorization =""&CalendlyApiKey],
    Source = Web.Contents(RelativePathString, [Headers=Headers])
in
    Source

2nd Try 

(eventId as text) =>
let
    Source = Json.Document(Web.Contents("https://api.calendly.com/scheduled_events/" & eventId & "/invitees", [Headers=[Authorization=""&CalendlyApiKey]]))
in
    Source

3dr Try 

(eventId as text)=>
let
    apiUrl = "https://api.calendly.com/scheduled_events/" & eventId & "/invitees",
    headers = [Authorization=""&CalendlyApiKey, #"Content-Type"="application/json"],
    jsonData = Json.Document(Web.Contents(apiUrl, [Headers=headers])),
    tableData = Table.FromRecords({jsonData}),
    expandedData = Table.ExpandListColumn(tableData, "collection"})
in
    expandedColumns

4th Try, this did not work due, "Token Literal expected.". I try "[RelativePath= ""&eventId"/invitees"" no luck

(eventId as text) =>

let
    Source = Json.Document(Web.Contents("https://api.calendly.com/scheduled_events/", [RelativePath= & eventId &"/invitees", [Headers=[Authorization=""&CalendlyApiKey]]
in
    Source

After trying out the steps mentioned above, I go ahead and invoke the function in the following manner:

let
  Source = nl_Events,
  #"Removed other columns" = Table.SelectColumns(Source, {"Event ID"}),
  #"Invoked custom function" = Table.AddColumn(#"Removed other columns", "Invoked custom function", each EventIDs([Event ID])),
  #"Expanded Invoked custom function" = Table.ExpandRecordColumn(#"Invoked custom function", "Invoked custom function", {"collection"}, {"collection"}),
  #"Expanded collection" = Table.ExpandListColumn(#"Expanded Invoked custom function", "collection"),
  #"Expanded collection 1" = Table.ExpandRecordColumn(#"Expanded collection", "collection", {"email"}, {"email"})
in
  #"Expanded collection 1"

Thank you so much 

[lbendlin]

Please follow the documentation. Use RelativePath the way it is intended.

Web.Contents - PowerQuery M | Microsoft Learn

[Zack92]

@lbendlin 

Thanks. I am trying to use RelativePath but getting an error call, Expected token near & eventID, I could not figure it out. 

(eventId as text) =>

let
    Source = Json.Document(Web.Contents("https://api.calendly.com/scheduled_events/", [RelativePath= & eventId &"/invitees", [Headers=[Authorization=""&CalendlyApiKey]]
in
    Source

[v-jialongy-msft]

Hi @Zack92 

Please try the scenarios mentioned in the documentation below:
Merging tables in Power BI dataflows with PRO subscription - Simple Talk (red-gate.com)

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Zack92]

@v-jialongy-msft  Thanks, but I am already using this method to remove enable loading and take the reference from the last table. For this issue, this does not work tho.