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
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 321 members 3,825 guests
Please welcome our newest community members: