Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

krishnateja

SAP BW returning error

Submitted by on ‎03-14-2017 04:39 AM

Hi All,

 

When I am trying to pull data from SAP BW Connector, it was returning me the below error.

 

Also, the response was very bad, is there any way to improve the performance. Please help

 

SAP BW -- 50 character issues in Power BI.JPG

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
salasks
New Member
‎03-14-2017 10:16 AM

I am getting the same error.

It is happening when pulling PowerBI Embedded files from Azure.

v-qiuyu-msft
Community Support
Community Support
‎03-14-2017 11:37 PM

Hi @krishnateja,

 

Did you specify the MDX query when connecting to SAP BW in desktop? If it is, please run the MDX statement on your SAP System to see if same error occur. Also please try to run the latest desktop version 2.44.4675.521.

 

Regarding the issue that the response is very bad, this often indicates that the question being asked by the user is too complicated or involves too much data, perhaps because they're including too many dimensions. The solution is usually to reduce the number of dimensions, splitting big queries. You need to check whether the MDX statement runs faster significantly on SAP side firstly.

 

@salasks As the same error throws when you integrate with Power BI Embedded, it should be another scenario. Please post a new thread in this forum and share more details about the issue.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Impactful Individual
‎03-14-2017 11:39 PM
Status changed to: Needs Info
 
krishnateja
Frequent Visitor
‎03-15-2017 01:54 AM

Firstly I am very happy to see the response.

 

I am just pulling 25 records with one dimension and one metrics, which was quite a simple thing also I am not using any MDX expression.

Below are our queries:

 

1.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.

 

2.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?

 

is there any way to filter data before coming to Power BI from SAP BW cubes

Idea Statuses