I need help! Connect to SAP BW application store

[alops]

Hi everyone, I have a problem with a PBI Desktop report that uses BW queries, SAP tables with an ODBC connection and Excel files via Sharepoint as a connection, these tables are all put in an appendix in a single final table. For a few days when I try to update the report on PBI Desktop I get this error:

OLE DB or ODBC error: [DataSource.Error] The SAP BW server returned an error: 'System error in the CL_RSMD_RS_READ_MDATA program and in the Form _EXECUTE_REQUEST-10-'. For more information on this error, visit the SAP technical support site and search for 'BRAIN 299'. More information may be available in SAP Note '1304564, 2632620'.

I searched around for a while and found nothing, I really need help.

here are some details that may help:

- the report is normally updated on PBI Service and does not give any errors

-when I enable to load a table with ODBC connection, I can update without problems.

[v-yingjl]

Hi @alops ,

You can refer these documents when connecting to SAP BW from power bi desktop:

1. Microsoft Power BI and SAP BW Data Warehouse Connectivity step by step 
2. Use the SAP Business Warehouse connector in Power BI Desktop 

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