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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
KL_SARA
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

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
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

5 REPLIES 5
v-shex-msft
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

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.

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
If this post helps, please consider accept as solution to help other members find it more quickly.

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors