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.
Hello.
I tried to load the table in XML from the following page:
"https://home.treasury.gov/resource-center/data-chart-center/interest-rates/pages/xml?data=daily_trea..." but I couldn't understand how to generate the information structure in power query.
I don't know how to build the information.
Solved! Go to Solution.
let
Source = Xml.Tables(Web.Contents("https://home.treasury.gov/resource-center/data-chart-center/interest-rates/pages/xml?data=daily_trea...")),
Custom1 = Table.Combine(List.Transform(Source{0}[entry][content],each Table.TransformColumns(Table.FirstValue(Table.FirstValue(_)[properties]{0}),{},Table.FirstValue)))
in
Custom1
let
Source = Xml.Tables(Web.Contents("https://home.treasury.gov/resource-center/data-chart-center/interest-rates/pages/xml?data=daily_trea...")),
Custom1 = Table.Combine(List.Transform(Source{0}[entry][content],each Table.TransformColumns(Table.FirstValue(Table.FirstValue(_)[properties]{0}),{},Table.FirstValue)))
in
Custom1
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.