Forum Discussion
Martynas_BI
2 years agoFrequent Visitor
Using Alphavantage API in Power Query produces an error
Hi, I've been trying to get financial data (Income Statement, in particular) relating to public stocks from Alphavantage API, which is free. https://www.alphavantage.co/documentation/ This i...
Martynas_BI
2 years agoFrequent Visitor
Column1 (and you can see the error, which contains "quarterlyReport"). Unfortunately, I can't simply just remove errors, as when I do even though everything looks fine in PQ, when I apply and load I get the aforementioned error in Desktop.
- lbendlin2 years agoSuper User
Remove errors and then expand the column. Read about how to handle missing columns
- Martynas_BI2 years agoFrequent Visitor
I might be missunderstanding something, but as I just said, this approach didn't work as I've tried it