Forum Discussion

NovaBI's avatar
NovaBI
Icon for Post Patron rankPost Patron
6 years ago

How to filter parameters and variables when importing import 2.0 with SAP

Hello together,

 

I am using the latest BI connector to get data from SAP BW. I am applying Import (Data Connectivity mode) and 2.0 (Implementation, i.e. SAP Net Connector 3.0).

 

I know that the Queries can be customized within SAP itself, but sometimes I'd need to build a quick solution within PowerQuery itself to filter the paramters. In my case, i'd like to pull only year with the beginning 20xx and 21xx (year +1 = current year, do not wonder):

 

 

I can filter somehow (see the "select all search results"), but i dont know how to filter like "show me only everything >= xyz".

 

Perhaps someone can help me out here, thanks so much in advance!

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi NovaBI 

    Add a column and apply "number filters" on it.

    Follow steps below:

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • NovaBI's avatar
      NovaBI
      Icon for Post Patron rankPost Patron
      6 years ago

      Hi Maggie,

       

      thanks for the answer.

      This is not what I was looking for. Transforming the data after the Extract from SAP is not the issue.

      I want to avoid importing every PSI version from 4 years, as it creates a long load due to additional columns (around 16) that create tons of variations / rows.

       

      I need to restrict the import of the PSI's versions when importing the Data, i.e. before i start using the filters from PowerQuery.

       

      I am looking for a filter method in the SAP-Connector.