Forum Discussion

Rehab_hassan's avatar
Rehab_hassan
Frequent Visitor
6 years ago
Solved

limit data range when using the import method

Hello all,   my coroporate data is for many years and I need to limit the import to the last 5 years so that it wont take much space. Any idea how i can do that?
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Rehab_hassan ,

    Check this option wile Get Data->SQL server


    Regards,
    Amit

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Rehab_hassan ,

AFAIK, some of the data connectors support to add advanced option queries to filter on received data before import data to power bi. (e.g. SQL, oracle...)

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5

For dynamic date filter, you can consider splicing query string with query parameters or m query DateTime functions.

Deep Dive into Query Parameters and Power BI Templates

dynamic date filter

Regards,

Xiaoxin Sheng