Extract data from blob url, facing dynamic source error before saving the query

Hi anusha_madhavan,

Thank you for reaching out to Microsoft Fabric Community.

The issue here is because the power bi dataflows do not allow fully dynamic URLs in Web.Contents. Please use this below M query:

let
Url = "https://api.github.com/enterprises/" & Enterprise & "/copilot/metrics/reports/users-28-day/latest",
Source = Json.Document(Web.Contents("https://api.github.com/", [RelativePath="enterprises/" & Enterprise & "/copilot/metrics/reports/users-28-day/latest"])),
download_links = Source[download_links],
blobUrl = download_links{0},
blobBaseUrl = "https://github.com/",
blobPath = Text.AfterDelimiter(blobUrl, "github.com/"),
blobContent = Lines.FromBinary(Web.Contents(blobBaseUrl, [RelativePath=blobPath])),
blobData = Table.FromColumns({blobContent}, {"RawJson"}),
parsedJson = Table.TransformColumns(blobData, {"RawJson", Json.Document}),

expandedData = Table.ExpandRecordColumn(parsedJson, "RawJson", {"report_start_day", "report_end_day", "day", "enterprise_id", "user_id", "user_login", "user_initiated_interaction_count", "code_generation_activity_count", "code_acceptance_activity_count", "generated_loc_sum", "accepted_loc_sum", "totals_by_ide", "totals_by_feature", "totals_by_language_feature", "totals_by_language_model", "totals_by_model_feature", "used_agent", "used_chat"}, {"report_start_day", "report_end_day", "day", "enterprise_id", "user_id", "user_login", "user_initiated_interaction_count", "code_generation_activity_count", "code_acceptance_activity_count", "generated_loc_sum", "accepted_loc_sum", "totals_by_ide", "totals_by_feature", "totals_by_language_feature", "totals_by_language_model", "totals_by_model_feature", "used_agent", "used_chat"}),

changedTypes = Table.TransformColumnTypes(expandedData, {{"report_start_day", type date}, {"report_end_day", type date}, {"day", type date}, {"enterprise_id", Int64.Type}, {"user_id", Int64.Type}, {"user_login", type text}, {"user_initiated_interaction_count", Int64.Type}, {"code_generation_activity_count", Int64.Type}, {"code_acceptance_activity_count", Int64.Type}, {"generated_loc_sum", Int64.Type}, {"accepted_loc_sum", Int64.Type}, {"used_agent", type logical}, {"used_chat", type logical}}),

#"Transform columns" = Table.TransformColumnTypes(changedTypes, {{"totals_by_ide", type text}, {"totals_by_feature", type text}, {"totals_by_language_feature", type text}, {"totals_by_language_model", type text}, {"totals_by_model_feature", type text}}),
#"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"totals_by_ide", null}, {"totals_by_feature", null}, {"totals_by_language_feature", null}, {"totals_by_language_model", null}, {"totals_by_model_feature", null}})
in
#"Replace errors"

Thanks and regards,

Anjan Kumar Chippa