Forum Discussion

ncbshiva's avatar
ncbshiva
Advocate V
7 years ago
Solved

Dynamic Parameters with SAP BW BEX

Hi Team,   I am using the SAP BW for connecting the data. I have 6 years of data . Initially i am pulling only 2 years of data into Power Bi desktop, so that i wont get any memory issues when i try...
Need Help
  • ncbshiva's avatar
    ncbshiva
    7 years ago

    I was able to achieve this solution with help of some blogs.

     

    Below is the example on how to pass the parameters in the SAP BW query.

     

    First you need to define your parameter , in my case it was Fiscal Year

     

    #"GetParameterValue" = "[" & (Fiscal_year) & "]",

     

    Then you need to use the above parameter in the cubeApplyParameter query as shown below.

     

    {Cube.ApplyParameter, "[0S_FYEAR]", {{"[0FISCYEAR]." & #"GetParameterValue", "[0FISCYEAR]." & #"GetParameterValue" }}},

     

     

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

So your single query can load 1 year of data into PowerBI, and after that you loaded total of 3 years of data into powerbi service using parameter using that single query? and its working fine every since?

ncbshiva's avatar
ncbshiva
Advocate V
6 years ago

yes , everything is working fine without any issues.

Moreover i am using Power BI Premium for this.

  • Anmolgan's avatar
    Anmolgan
    Post Prodigy
    6 years ago

    Is there any reason for using powerbi premium? what is your SAP BW System configurations??

  • Anmolgan's avatar
    Anmolgan
    Post Prodigy
    6 years ago
    Do you know of any ways to perform delta load for SAPBW into powerbi service?
  • ncbshiva's avatar
    ncbshiva
    Advocate V
    6 years ago

    To use linked entities i am using Premium service and i dont know about the SAP BW configurations.

    That is being maintained by some other team