Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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.
Regards,
Xiaoxin Sheng
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
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