Forum Discussion

Do5779's avatar
Do5779
Helper II
4 years ago
Solved

Website Data

Hello all,

I have the following problem: I want to take data from a website that is hidden by a search mask. The URL does not change, so it cannot be accessed in this way. For example the historical oil prices on the website
https://www.finanzen.net/rohstoffe/oelpreis/historisch. If I want to open or import them directly in Power Bi, the interface remains empty and I cannot load the table.

 

Another idea is that I access the prices from the first page (https://www.finanzen.net/rohstoffe/oelpreis). But this is only 14 days. I need as long a period as possible. So it would be good at each update to add only the newest prices to the existing ones and not to exceed the complete data. .

 

Here you can see the 14 daily overview. So If there is a new price, e.g. 25.07.2022. I need the 11 prices (10 of the picture and the new one)

 

 

 

As far as I had read it should work about incremental loading. However, neither the videos nor the microsoft explanation helps me how to set the dynamic change of the dates. I have a RangeStart and RangeEnd and a filter on the data, but there is no possibility to activate the item

 

 

 

 

 

 


A solution via an upstream database/per Phyton or similar is not possible just as I have not found a free API to retrieve. I would really appreciate any ideas or help.

 

 

2 Replies