SAP BW returning error

[krishnateja]

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

[salasks]

I am getting the same error.

It is happening when pulling PowerBI Embedded files from Azure.

[v-qiuyu-msft]

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

[krishnateja]

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