Web source for inflation and fx

[mfc]

Hi there

I am trying to find a good web site source for inflation and FX, that I can connect directly to Power BI. I have tried the web of the World Bank where they have all this data al global level, but is not connecting to the tables  from these websites:

https://data.worldbank.org/indicator/FP.CPI.TOTL.ZG

Does anyone has another soure for inflatoin and FX easy to connect from Power BI?

Thanks very much,

mfc

[parry2k]

@mfc which table on that site you are trying to connect to, can you share the screen shot?

[mfc]

@parry2k This table: https://databank.worldbank.org/reports.aspx?source=2&series=FP.CPI.TOTL.ZG&country=

[v-easonf-msft]

Hi , @mfc 

After my test, you can directly get data from web after  entering the web url.

For more detail ,please refer this Tutorial

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mfc]

v-easonf-msft, thanks for your answer, the problem I had and still have, is that for some reason the table get loaded only until Cuba. Any idea on why the table migth get loaded only partly? Thanks very much, I really appreciate your help`!

[v-easonf-msft · Accepted solution]

Hi , @mfc 

I suspect this is because the website will only load part of the data in the beginning. When you continue to pull down the table, the website will continue to send queries to the background to load the rest data.

When you use  "connect to web", the data storage mode is  import .

Since it is so, it will be a better choice to download the data in excel  and import it into powerbi.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.