I have a table which contains information from the "Stocks" data type. In column A, I have the stock data (where I enter the stock ticker and the base data appears showing stock name, ticker, exchange) and in other columns I have other data like Price, Last Trade Time, Currency etc.

I wanted to make a Power Query to group according to the stock data, column A. However when the Power Query editor appears, all the data in column A which the stock base data shows up as "error". The other columns with, Price, Last Trade Time, currency appear correctly and without errors in Power Query.

Is there a setting or work around to get Power Query working  correctly with Data Type _ Stocks?

Regards