Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

SAP BW performance issue and direct object connectivity

@GuyInACube I am a huge follower of you, I am very much benefited by your knowledge sharings, I moved to POWER BI support team recently, User is raising the concerns on the POWER BI Performace while pulling data from SAP BW cubes. 


Here is the request:


Currently, I’m accessing the SAP-BW Dev environment through the PowerBI connection and I’ve been experiencing very slow connection issues. Each action within PowerBI, from establishing a connection to the data source, navigating in the data source listing and making any modifications to the query output is painfully slow.


for the above: can we keep a trace on the user machine to find was causing the issue or is it a tool limitation.


She was also trying to find out if she can build PowerBI queries on SAP-BW master data objects (i.e. standard SAP-BW master data object 0MATERIAL). as It seems the only way to do this is to first create an SAP-BI query that references this master data object, add all the fields needed, save and then it can be visible in PowerBI info provider listing. she was hoping to avoid the entire step of creating a query and just do a direct connection to the object itself. Is there a way to accomplish this approach?


we went through the power bi technical documentation to connect with SAP BW but I didn't see options to get to SAP Object directly.


Please do help.



Thanks in advance 





Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.