Forum Discussion

Casingena's avatar
Casingena
Frequent Visitor
5 years ago
Solved

Issue with missing complex columns based on data source

Hi everyone,   I have been struggling with an issue regarding a data source. I have 4 tables that are spread across 4 sheets in an Excel workbook. There are relationships between the tables as show...
Need Help
  • Casingena's avatar
    Casingena
    5 years ago

    amitchandak, thanks for your quick response. With the navigation step selected I am still unable to see the complex columns:

    I have just discovered that I have been importing the tables using Get Data > Excel. If I go to the File menu and choose Import > Power Query, the complex columns do appear, however I receive other issues. I think I can work on these seperately, but I think I understand that Get Data > File simply grabs the tables and Import > Power Query adopts the data model from Excel.

Casingena's avatar
Casingena
Frequent Visitor
5 years ago

amitchandak, thanks for your quick response. With the navigation step selected I am still unable to see the complex columns:

I have just discovered that I have been importing the tables using Get Data > Excel. If I go to the File menu and choose Import > Power Query, the complex columns do appear, however I receive other issues. I think I can work on these seperately, but I think I understand that Get Data > File simply grabs the tables and Import > Power Query adopts the data model from Excel.

amitchandak's avatar
amitchandak
Super User
5 years ago

Casingena , Power Query can get an excel table. How is access column is created