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

SAP BW 7.5 on HANA- Power BI connectivity issue

Hello,

 

We are trying to integrate data from SAP BW using Power BI SAP BW direct connector in Power BI Desktop. We are connected to domain and able to communicate with SAP BW server. When we used SAP BW server before migration/upgrade to BW 7.5 on HANA, we were able to extract data from the system and the test is successful, however, after migrating to SAP BW 7.5 on HANA, we are not able to extract fields from the Cube, even if the connection with BW system has been done. We did a test where we selected desired measures and dimensions, it starts "Loading into Data Model".

After some time, it pops up below error message:

 

DataSource.Error: SAP Business Warehouse:

Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'

 

Can you please help me to solve this issue ?

Thanks,

 

Best regards,

 

Sara

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: SAP BW 7.5 on HANA- Power BI connectivity issue

Hi @KL_SARA,

 

As I mentioned, if your bw datasource has already migration/updated to hana, it will be suitable to switch your connector to hana.

In addition, please check your client version to use the match version and bit(32/64) client to connect your data.

 

BTW, if any compatible issue appears after migration/update, you can post them to sap forum to get further support.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
5 REPLIES 5
Community Support Team
Community Support Team

Re: SAP BW 7.5 on HANA- Power BI connectivity issue

Hi @KL_SARA,

 

>>When we used SAP BW server before migration/upgrade to BW 7.5 on HANA, we were able to extract data from the system and the test is successful, however, after migrating to SAP BW 7.5 on HANA, we are not able to extract fields from the Cube, even if the connection with BW system has been done. We did a test where we selected desired measures and dimensions, it starts "Loading into Data Model".

I just want to know why don't you use the matched connector to connect the database?

 

Current Power bi already contains SAP BW and SAP HANA connectors.

11.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
KL_SARA Frequent Visitor
Frequent Visitor

Re: SAP BW 7.5 on HANA- Power BI connectivity issue

Hello @v-shex-msft,

 

Thanks for your response.

 

We used the connector SAP BW Server, and the connection with BW system has been done. But when we tried to extract data from the cube, After some time, it returns this error mentioned. I did the same test by connecting to the server BW before migration/update on sap hana (version 7.4), and the test is successful, but it's not the same case for bw server after migration/update on sap hana 7.5.

 

Please share if you have any suggestions.

Thanks,

 

Regards,

 

Sara.

Highlighted
Community Support Team
Community Support Team

Re: SAP BW 7.5 on HANA- Power BI connectivity issue

Hi @KL_SARA,

 

As I mentioned, if your bw datasource has already migration/updated to hana, it will be suitable to switch your connector to hana.

In addition, please check your client version to use the match version and bit(32/64) client to connect your data.

 

BTW, if any compatible issue appears after migration/update, you can post them to sap forum to get further support.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
KL_SARA Frequent Visitor
Frequent Visitor

Re: SAP BW 7.5 on HANA- Power BI connectivity issue

Hello @v-shex-msft

 

Thanks for your response.

Actually we had a problem regarding MDX PARSER connection after migrating to SAP 7.5 on HANA, we posted it to sap forum and the problem is solved. 

 

Thank you, 

 

Best regards,

Sara

Re: SAP BW 7.5 on HANA- Power BI connectivity issue

Hi Sara - 

 

Not sure if this is the place to ask, but what sort of improvements did you see in your connection after the upgrade to HANA? 

 

Thanks!

FH

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 415 members 4,363 guests
Please welcome our newest community members: