Connecting to web for finance index data

[JJ2022PBI]

Hi,

I am clicking on 'Get data' then clicking 'Web' and then entering the URL of the website where I have found some data but Power BI says it doesn't recognise the data within the URL.

Does anyone know of a good source to get a table of finacial index data, for example the FTSE100 or S&P500 that can link to Power BI?

Thanks,

James

[some_bih]

Hi @JJ2022PBI Oh, you probably need python script 🙂 Check solution https://community.fabric.microsoft.com/t5/Desktop/fetching-financial-data-of-public-companies-in-pow... 

Hope this help

[JJ2022PBI]

Hi @some_bih. I've read this docuemnt already, my issue is that not every website has their data structured in a way that Power BI can easily read.

I was wondering if anyone knew of a good source for financial market data?

Thanks

[some_bih]

Hi @JJ2022PBI check tutorial https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-to-web  Hope this help