Remove nested tables on import from Business Central 365

[ChristineC]

Hi,

I'm having an issue importing data from Business Central into Power BI. I believe there is an error on a nested table, but I do not know the query language well enough to resolve this issue.

I cannot preview my Sales table due to the error. I performed a Table.Schema(sales_table) query to find the following information:

The specific fields and lines it is referring to above, relates to the nested tables inside my parent table.

Above are the three tables nested inside my "Sales" table , that I would like to ideally remove or at least resolve. 

Please could someone help with this?

Many thanks,

Christine 

[lbendlin]

Do you need the information from these nested table columns? Could you exclude them in your original query?

[ChristineC]

Hi, 

Thank you for replying. I do not need the information from these nested table columns.

However, by default they are included when I try to import the table.

Could you give an example query of how to exclude these tables when importing the parent table?

Many thanks,