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 everyone,
Is it possible to get the data out of the tables from the following web page?
https://www.cftc.gov/dea/futures/deacmelf.htm
I struggle to import the data as a table. The only option I identified so far is to get the data as a text file and model into tables.
Thanks a lot,
Max
Hi @Anonymous ,
Generally, data in a website are stored in a json or xml, but in your scenario, the table use the "." and ":" as the spliter of column and row, the table isn't using the normal format, PowerBI can't handle it directly.
You can consider using Python and Regular Expression to get the data, but it is not easy.
Best Regards,
Teige
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.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |