Hi Anybody, I need help. My M following M code works in desktop version. But when I try publish Power BI service I get the following error "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.". As you see in the code below I am using relative path and query. What am I missing? Any help provided is much appreciated.
let
APIName = "scans",
myList = GetbaseURLAndAPIKeyAndlimit(),
baseURL = myList{0},
APIKey = myList{1},
mylimit = myList{2},
header = [#"x-apikey"= APIKey],
//extendedURL = baseURL & APIName & mylimit,
myList1 = {APIName, mylimit},
extendedURL = Text.Combine(myList1),
Source = Json.Document
(
Web.Contents
(
baseURL,
[RelativePath = extendedURL,
Headers = header]
)
),
Source1 = Source,
#"Converted to Table" = Table.FromList(Source1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"scan_id", "scan_type", "scan_date", "scan_description", "scan_mitigated", "asset_count", "scan_file_name", "finding_count_critical", "finding_count_high", "finding_count_medium", "finding_count_low", "finding_count_informational", "finding_count_pass", "finding_count_fail", "finding_count_warning"}, {"Column1.scan_id", "Column1.scan_type", "Column1.scan_date", "Column1.scan_description", "Column1.scan_mitigated", "Column1.asset_count", "Column1.scan_file_name", "Column1.finding_count_critical", "Column1.finding_count_high", "Column1.finding_count_medium", "Column1.finding_count_low", "Column1.finding_count_informational", "Column1.finding_count_pass", "Column1.finding_count_fail", "Column1.finding_count_warning"})
in
#"Expanded Column1"
