Forum Discussion

DizerX's avatar
DizerX
Frequent Visitor
2 years ago

Return non-zeros and non-empty values from SAP BW Application Server Connector

Hello Gurus,   I'm using SAP BW Application Server connector to extract some data from SAP BW.   Previously, when I used to query the same data from "Analysis for Office" plugin in Excel, the out...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DizerX ,

You can try to use the Table.SelectRows function to filter out rows based on your criteria. For example, you can exclude rows where the measure values are null or zero.
Here is a sample:

FilteredRows = Table.SelectRows(#"....", each [Closing Stock] <> null and [Closing Stock] <> 0)

If you’re familiar with the structure of your data, you can apply filters to specific columns to only retrieve rows with non-empty values in those columns.
And consider using the Table.RemoveColumns function to remove unnecessary columns from your query, which can reduce the amount of data being processed and potentially speed up the extraction.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DizerX's avatar
DizerX
Frequent Visitor
2 years ago

Hi Dino, Thank you for your reply.

 

Wouldn't that mean that the server side is still processing and sending the large data set into Power Query only to be filtered later on? Wouldn't this result in the same slow performance?

 

The idea was to get the server side to only process and send the non-zero data from its side to avoid the huge time the data needs to be processed before it's received into my Power Query.