Excel Power Query: Cannot query internal supporting structures

Question

I have been trying to pivot my data for my attempts and face errors each time in Microsoft Excel.

Tracing my steps:

1. Load data: Data ribbon >> Get data >> From folder
2. Edit and transform data: I split a string column into two columns, date column and time column. Date column is in date format, time column is in time format.
3. Load data to: I select Only Crate Connection and tick Add this data to the Data Model
4. Power pivot data: I tick the date variable to add to the pivot chart. (I also tried the same thing but with pivot table)
   At this step, I always receive the error message:

The query did not run or the Data Model could not be accessed. Here's the error message we got:

Cannot query internal supporting structures for column 'date' because they depend on a column, relationship, or measure that is not processed. Please refresh or recalculate the model.

When I click OK, excel notifies me that it will surface the error, and my excel programme automatically closes.
Can anybody advise which of the above step was wrong?
I tried tons of times but each time the error message pops up. I am not sure what is the colum, relationship or measure my date column is dependent upon, since there is no calculation incorporated in the raw data.

Tried to find other forums, but there aren't any conclusive answers.

Thank you.

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--