Forum Discussion

jsconcepcion's avatar
jsconcepcion
Regular Visitor
2 years ago
Solved

Dataflow Gen2 and nested tables

Im working on a Power BI report development project and the main data source is a datalake which I connect via ODATA. I have setup few dataflows for it. Ive read the documentation and found out that ...
Dataflow
  • lbendlin's avatar
    lbendlin
    2 years ago
    After I publish the dataflow and come back later, an additional step was automatically added that removes all columns with nested tables. I really need those columns

    in order to be used in a dataflow or dataset semantic model the result of a Power Query must be in tabular format and must contain only basic column types.  No objects (like nested tables) are permitted.

lbendlin's avatar
lbendlin
Super User
2 years ago
After I publish the dataflow and come back later, an additional step was automatically added that removes all columns with nested tables. I really need those columns

in order to be used in a dataflow or dataset semantic model the result of a Power Query must be in tabular format and must contain only basic column types.  No objects (like nested tables) are permitted.

  • jsconcepcion's avatar
    jsconcepcion
    Regular Visitor
    2 years ago

    I can see that now. Thank you!