Forum Discussion
API load more than one URL and after refresh show empty
Hi Anonymous, thank you for your message.
The issue was not resolved, but I already found the way to fix it.
Thank you again.
Daniel
Source data storage solution? I never said that.
And I already made it. I used a function and a query that give me the rows that I need. This part of the code has a problem, when I refresh it again, the table shows empty:
Detalle =
if List.Count(Codigos) = 0 then
DetalleVacio
else
let
// Ejecutar la función para cada código
Tablas = List.Transform(Codigos, each URLconCodigo(_)),
// Forzar el código en cada tabla ANTES de combinar
TablasConCodigo =
List.Transform(
List.Positions(Codigos),
(i) =>
let
t = Tablas{i},
c = Codigos{i},
tConCodigo = Table.AddColumn(t, "Código Licitación", each c, type text)
in
tConCodigo
),
// Combinar todas las tablas
Combinado = Table.Combine(TablasConCodigo)
in
Combinado,
What a shame that my post was not understood.
Regards,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523