cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

SAP BW Data Filtering Prior to Connection

Is there a way to control how much data is being pulled into Power BI from a SAP BW query?  For instance, our system has data available from 2012 to current.   I only need to pull in 2016-2017 data.  I would like to be able to control the date range in the connection process so that the download is much quicker.  It is currently waisting time pulling in 2012-15 data I do not want and have to filter out of my results.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-ljerr-msft
Microsoft

Re: SAP BW Data Filtering Prior to Connection

Hi @ReynoldsTstan16,



by filtering the data this way will it speed up the process of refreshing the data from BW?

Yes, it will speed up the process of refreshing by filtering the data from BW this way(instead of loading the entire set of rows into the Power BI Desktop data model). Smiley Happy

 

Regards

View solution in original post

5 REPLIES 5
Microsoft v-ljerr-msft
Microsoft

Re: SAP BW Data Filtering Prior to Connection

Hi @ReynoldsTstan16,

 

In this scenario, you can filter on your date column in Query Editor to specify a set of rows which you want to be finally brought into the Power BI Desktop data model. Smiley Happy

  1. Select the date column you want to filter on.

  2. Click the down arrow ( Down arrow ).

  3. Click Date Filters, and select After.
  4. Pick a Date range you need, then click OK.

f1.PNG

 

Regards

Re: SAP BW Data Filtering Prior to Connection

I saw that option....by filtering the data this way will it speed up the process of refreshing the data from BW?

Microsoft v-ljerr-msft
Microsoft

Re: SAP BW Data Filtering Prior to Connection

Hi @ReynoldsTstan16,



by filtering the data this way will it speed up the process of refreshing the data from BW?

Yes, it will speed up the process of refreshing by filtering the data from BW this way(instead of loading the entire set of rows into the Power BI Desktop data model). Smiley Happy

 

Regards

View solution in original post

Re: SAP BW Data Filtering Prior to Connection

Thx for your feedback...much appreciated!

TORNALLY Frequent Visitor
Frequent Visitor

Re: SAP BW Data Filtering Prior to Connection

This might not answer your specific question, but you should take a look at the Simplement Data Liberator.  

 

          www.simplement.us

 

This platform surfaces SAP tables effortlessly and in real-time.  You can define exactly what you want to bring over.  It places all these tables directly into SQL Server, ready for Power BI.

 

   Mike McNally

mmcnally@simplement.us

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,668)