Not able to get correct data in Power BI

[ShraddhaB1990]

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

[v-juanli-msft]

Hi @ShraddhaB1990 

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.

[Mariusz]

Hi @ShraddhaB1990 

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