Forum Discussion

dplandry's avatar
dplandry
Regular Visitor
9 years ago

EXTRACT DATA FROM TABLES BEFORE ARCHIVE

Hey guys

 

I'm pretty new to Power BI, but am learning fast and loving it.   I am trying to build a report on deleviry effeciency, but the main table I need to use to pull data is archived such that only the recent 6 months of data ramains in the table....beyond that it's moved to another archive table.  I'm having issues getting the data from the sales orders to pull from each table.  Is there a way to extra the data from the current data into a new table before it's archived and removed?

 

Thanks

Dwaye

 

Need Help

4 Replies

  • MEhrenmueller's avatar
    MEhrenmueller
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago

    Hi!

     

    What troubles do you face when you extract the data from both, the "current" and the "archive" table?

    This should work pretty straight forward.

     

    I am not aware of a possibility to extract data (from your "current" table) and "hold" it in PowerBI without getting it refreshed.

    • dplandry's avatar
      dplandry
      Regular Visitor
      9 years ago
      I'm having a problem linking the current table to the archive table. In the order table, the sales order appears once. The archive table holds sales order lines so the sales order appears more than once so I'm having issues linking them. If I use the main table, I only get 6 months of sales orders.
      • MEhrenmueller's avatar
        MEhrenmueller
        Icon for Most Valuable Professional rankMost Valuable Professional
        9 years ago

        Can you support me with more details about the (useful) columns of both tables?

         

        From the knowledge I have so far about your case, it should be possible to GROUP the archive table when you load it via Power Query, so you get down to the expected number of rows.