cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 2
Highlighted
Super User V
Super User V

Re: Not able to get correct data in Power BI

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

 

Highlighted
Community Support
Community Support

Re: Not able to get correct data in Power BI

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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors