Forum Discussion

chahine's avatar
chahine
Iron Contributor
Sep 04, 2021

Importing data from web (java/css)

Hello, i have one concern, i want to get data from this website https://lirarate.org/, particularly i want the excel file from the graph.  is there a way to put the link of this graph so that power query will update by simply a refresh , now i need everytime to download the csv/excel file from the button in the graph, i want it to be automatic, but unable to find the link to this file 

 

Any suggestions?

BI & Data Analysis
excel

1 Reply

  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Bronze Contributor
    Sep 04, 2021
    I would suggest you to get the data from other sources

    https://www.investing.com/currencies/usd-lbp-historical-data
    https://tradingeconomics.com/lebanon/currency

    There you can get an API where you can connect to Excel via Power Query and download the data.

Resources