Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Not able to get correct data in Power BI

Hello All,

I have issue while getting the data from sap bw to power bi.

The query is having few parameters.

If i am executing the query in SAP BW i am getting all the data as required with/without parameter. however i am not able to get the required data in Power bi with/without parameter. I am getting few rows of data in power bi however that is incomplete data.

Can anyone help me on this!!!

 

Regards,

Shraddha

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    If you looking at Power Query, you most likely do not need to worry as PQ will preview data and not pull all of it, all data should come through into the model one you click Close & Apply, it's designed so you can develop without putting an unnecessary strain on the data source.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

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

    Hi Anonymous 

    Do you connect to dynamic parameter with SAP BW BEX query into Power bi?

    If so, you could refer to solved thread here:

    https://community.powerbi.com/t5/Desktop/Dynamic-Parameters-with-SAP-BW-BEX/td-p/623453

    add query in Advanced editor of Power query(inside transform data)

     

    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.