Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community,
I am new in general to editing power query code so please be gentle and explicit in your guidance 🙂 I am querying SAP BW, and trying to limit data extracted (vs. filtering after it loads in PQ).
In the highlighted step below, I would like to not have to specify individual values, and instead, either use:
Add Items expects individual selection for this parameter (see below). Is what I want to do even possible?
TIA
Hi @klp97, did you find a solution for this problem? I am exploring the exact same issue at the moment...
Hi @klp97
You can try using a MDX statement to filter when you first configure the connection. Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Learn
The Basic MDX Query (MDX) | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
Hello, thank you for the suggestion. I am not familiar with writing MDX queries - do you have any specific guidance on how I might write the query for what I would like to accomplish?