Getting the dreaded error:
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"[Unable to combine data] Section1/Transactions - 2/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}}],"exceptionCulprit":1}}} Table: Transactions - 2.
I've read many blogs re this and the formula.firewall as well. And I've tried to build a staging table and to play around with private/public.
I'm calling a REST API first to get the number of total records because I since have to call it again to retrieve 1000 records at a time.
I've tried to simplify my below code to only include things of relevance.
Thing works like a charm in Desktop.
// baseURL
"https://restapi.e-conomic.com/" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]
// paramPageSize
"1000" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=false]
// XAppSecretToken
"Secret" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=false]
// XAgreementGrantToken
"SecretToo" meta [IsParameterQuery=true, List={"daUNWgKLrEBftRnbME4ZtPXJToDk0uKW1npHxvHA6JM1"}, DefaultValue="daUNWgKLrEBftRnbME4ZtPXJToDk0uKW1npHxvHA6JM1", Type="Text", IsParameterQueryRequired=false]
// Transactions - 1
let
Kilde = Table.SelectColumns(Regnskabsår,{"URLposteringer"}),
#"Extract URL" = Table.AddColumn(Kilde, "Tekst efter afgrænser", each Text.AfterDelimiter([URLposteringer], baseURL), type text),
#"Remove column" = Table.RemoveColumns(#"Extract URL",{"URLposteringer"}),
#"Rename column" = Table.RenameColumns(#"Remove column",{{"Tekst efter afgrænser", "Endpoint"}})
in
#"Rename column"
// Transactions - 2
let
Kilde = #"Transactions - 1",
#"Aktiveret brugerdefineret funktion" = Table.AddColumn(Kilde, "fnAPIrecords", each fnAPIrecords([Endpoint])),
#"Udvidet fnAPIrecords" = Table.ExpandTableColumn(#"Aktiveret brugerdefineret funktion", "fnAPIrecords", {"Records"}, {"Records"})
in
#"Udvidet fnAPIrecords"
// fnAPIrecords
let
Source = (paramURL as text) => let
Source = Json.Document(Web.Contents(
baseURL,
[
RelativePath=paramURL,
Query=
[
pagesize=paramPageSize,
skippages="0"
],
Headers=
[
#"X-AppSecretToken"=XAppSecretToken,
#"X-AgreementGrantToken"= XAgreementGrantToken,
#"Content-Type"="application/json"
]
]
)),
pagination = Source[pagination],
#"Convert to table" = Record.ToTable(pagination),
#"Filter rows" = Table.SelectRows(#"Convert to table", each ([Name] = "results")),
#"Remove columns" = Table.RemoveColumns(#"Filter rows",{"Name"}),
#"Rename columns" = Table.RenameColumns(#"Remove columns",{{"Value", "Records"}}),
#"Changed type" = Table.TransformColumnTypes(#"Rename columns",{{"Records", Int64.Type}})
in
#"Changed type"
in
Source
