topic Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record. in Power Query

An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

Aamir2021 — Fri, 24 Sep 2021 12:08:18 GMT

Hi,

I built 6 stock portfolio analysis model in excel on 17th Sep, 2021. I exracted stock price from Alpha Vantage web site with the help of Power Query. Data was looking on 17th Sep, 2021 as per below screen shot.

But problem is that I just have resfreshed power query and getting an error that as per below screen shot. I don't know what's wrong with it.

It would be greatly appreciated if you could help me out from this issue. You need that file please let me know.

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

mahoneypat — Fri, 24 Sep 2021 12:17:46 GMT

One of your steps (or the shown function) is referencing a column that is no longer there. You need to find the first step showing the error and remove that reference in the formula bar.

Pat

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

Aamir2021 — Fri, 24 Sep 2021 12:32:03 GMT

Thanks for your update. However I am still not getting your point for which I am attaching some more screen shot for your reference.

In my power query I created a function and a table name is Table3

I exracteded the data from Monthly TIme Series from Alpha Vantage and used below web url as json

https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY&symbol=IBM&apikey=demo

Function in power query

Table3

It would be great if you advise me in detail. Your response will be highly appreciated.

Thanks again

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

mussaenda — Sun, 26 Sep 2021 07:47:51 GMT

Hi Aamir2021 ,

Try removing you last Changed Type step and do it again.

Hope this helps

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

v-kelly-msft — Mon, 27 Sep 2021 08:57:27 GMT

Hi Aamir2021 ,

The error shows that the Column "Monthly Time Series" cant be found,click the step "Invoked Custom Function" to check whether it occurs the error:

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

mussaenda — Mon, 27 Sep 2021 11:41:02 GMT

Hi Aamir2021 ,

Try removing this step and see if the error still occurs.

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

Aamir2021 — Thu, 30 Sep 2021 16:06:54 GMT

Thank you very much for your suggestion. However I have tried to follow your instruction but still geting the error.

I get error when I just refresh the query sometimes HeroMotoCo and sometimes in Dabur stock. However when I try to invoke stock through function then refesh the query then it shows the correct results.

As per below screen shots you can see that dabur.bse is showing error, however I have invoked it through function then it is showing table. Similarly you can see in another screen shot that heromotoco.bse is showing correct but heromotoco.bse is showing error as per screen shot.

I don't know what is I am missing in my query.

It would be great if you could look into again and would greatly appreciated if you could suggest on this again.

Thank you

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

Aamir2021 — Thu, 30 Sep 2021 16:30:10 GMT

Thanks for your suggestion. However still it not has been fixed. Please refer my screen shots for your refernce.

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

Syndicate_Admin — Thu, 30 Sep 2021 17:01:21 GMT

Thank you very much for your suggestion. However I have tried to follow your instruction but still geting the error.

I don't know what is I am missing in my query.

It would be great if you could look into again and would greatly appreciated if you could suggest on this again.

Thank you

Re: An error occurred in the ‘’ query. Expression.Error: The field 'Monthly Time Series' of the record.

RichardTam — Mon, 07 Feb 2022 04:26:55 GMT

Hi Aamir,

I am running into the same problem, have you found a fix yet?
I cant believe how cumbersome it is to make mircosoft products to talk to microsoft services.......

It wont tell me which query, which step or which part is has gone wrong......