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 III
Super User III

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors