Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Include Split Column by Delimiter into ROWS in Dataflows Power Query UI

    Vote (3) Share
    Brandon Casas's profile image

    Brandon Casas on 27 May 2020 06:04:03

    Ability to split column by delimiter into ROWS in Dataflows Power Query UI. This feature is already included in Power BI Desktop Power Query Split Column actions. Currently DataFlows only has Split Column into Columns and not Rows.

    Comments (1)
    Brandon Casas's profile image Profile Picture

    Martin K on 21 Apr 2021 15:43:36

    RE: Include Split Column by Delimiter into ROWS in Dataflows Power Query UI

    Whenever I need to split column values into rows, I design the query in PBI Desktop and copy it into dataflow.

    See this video from Guy in a Cube where he shows how to copy the query between Power Query and Power Query Online: https://youtu.be/YWp4FKzIBxM