Forum Discussion

neetu14's avatar
neetu14
Microsoft Employee
6 years ago
Solved

Dataflow Timeout

I am trying to create a dataflow with only partial values from a table. Is there a way to break the 1-year data into 4 months each and create 4 different dataflows using advanced editor. When I created a dataflow with entire 1-year data (Millions of records), it is taking more than 6 hrs to load that data in Power BI Desktop.

 

Dataflow
Need Help
  • nickyvv's avatar
    nickyvv
    6 years ago

    neetu14, 

    when you have connected to the 4 dataflows in Power BI Desktop like below (I added 2 as an example):

    You can join the queries back together with Append Queries:

4 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago

    Hi neetu14, 

    In the editor of the dataflow using a date/datetime column you can use relative filters.

    So you can choose Quarter 1 for dataflow 1, Quarter 2 for dataflow 2, etc.

    • neetu14's avatar
      neetu14
      Microsoft Employee
      6 years ago

      Thank you. it worked 🙂

       

      How do I connect these 4 dataflows together to get the complete data in 1 table in desktop like the original SQL table?

      • nickyvv's avatar
        nickyvv
        Most Valuable Professional
        6 years ago

        neetu14, 

        when you have connected to the 4 dataflows in Power BI Desktop like below (I added 2 as an example):

        You can join the queries back together with Append Queries: