" We couldn't get data from the Data Model" notification in Power Query

[Mai_Tran]

Hi guys

I have a simple file with only one table for testing. Office version I use is Office 2016.

After loading data from table to Power Query (PQ) then choose "Close and load to" I Can't load to both "Table" or "Only create connection add to data model"

When choosing Only create connection then click "add this data to the data model" here is notification I get:

When choosing Load to Table, here is notificaion I get:

Do you guys know what is wrong with my PQ or Excel?

[rubayatyasmin]

Can you clear the PQ cache and try again?

Also, check the thread to solve your problem,

How to rectify Excel error "We couldn't get the data from table in the workbook..." - Super User

or share the file here, let me try it.