Forum Discussion

bzeeblitz's avatar
bzeeblitz
Helper IV
1 year ago
Solved

Create data flow in powerbi

How to create power bi data flow for local files in my desktop let's say I have several files in my january folder in local desktop which has same file structure then now I have combined and loaded in my power bi so next step I need to create dataflow for the same scenario for combining files and create dataflow. Kindly suggest. 

2 Replies

  • bzeeblitz you need to use gateway to access files on on-prem computer. I would recommend putting file on sharepoint or one drive folder to avoid gateway.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi bzeeblitz ,
    Depending on your description, you can create a dataflow by importing a table
    Create a Dataflow Gen 1 in the workspace

    Add a new table

    Choose the data source in your folder

    You can choose upload

    Then in power query you can organize the data you want

    You can also refer to the following two documents

    Creating a dataflow - Power BI | Microsoft Learn
    Configure and consume a dataflow - Power BI | Microsoft Learn

     

    Best regards,
    Albert He


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly