Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am looking into appending a daily-updated set of .csv files from an API provided by one of our suppliers. These .csv files our named by the date they are reporting data for in the below highlighted format. Is it possible to automatically get these files and append them at the same time without any extra effort for linking separate files daily?
Zdroj = Csv.Document(Web.Contents("https://website/api/v2/export/power-bi/date/" & "2020-05-23" & ".csv"
Thanks,
Vit
Solved! Go to Solution.
Hi @Anonymous ,
If you have a table with dates, you can add a column and call this function inside it, like:
Csv.Document(Web.Contents("https://website/api/v2/export/power-bi/date/" & " Date.ToText([COLUMN], "yyyy-MM-dd") " & ".csv".
After that, just expand them and handle the headers, if necessary.
Also, you can create a function and call it inside the new custom column.
Hi @Anonymous ,
If you have a table with dates, you can add a column and call this function inside it, like:
Csv.Document(Web.Contents("https://website/api/v2/export/power-bi/date/" & " Date.ToText([COLUMN], "yyyy-MM-dd") " & ".csv".
After that, just expand them and handle the headers, if necessary.
Also, you can create a function and call it inside the new custom column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.