Forum Discussion
SAP Tables Data in PBRS
Hey all, I am unable to connect to SAP tables in PowerBI. If connected via ODBC refresh doesn't work. With HANA connector I am only seeing HANA views and not individual tables. Can someone please guide me?
Hi vyask,
By default, the SAP HANA connector treats HANA as a multidimensional source, which exposes Analytic/Calculation views in the Navigator-not base tables. To work with tables (or to write SQL), switch to relational mode: File -> Options ->DirectQuery ->“Treat SAP HANA as a relational source”, then create a new HANA connection. Details here: DirectQuery for SAP HANA (treat as relational source). If the Navigator still doesn’t list the table you need, use the connector’s Advanced options to paste an SQL statement (for example, SELECT * FROM SCHEMA.TABLE) as described in the Power Query HANA connector docs: Power Query SAP HANA connector.For the ODBC refresh failure, is your ODBC source referencing a system DSN? If so, the DSN will need to be made on the server hosting the Power BI Report server as well as on your machine.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.
5 Replies
Hi vyask,
By default, the SAP HANA connector treats HANA as a multidimensional source, which exposes Analytic/Calculation views in the Navigator-not base tables. To work with tables (or to write SQL), switch to relational mode: File -> Options ->DirectQuery ->“Treat SAP HANA as a relational source”, then create a new HANA connection. Details here: DirectQuery for SAP HANA (treat as relational source). If the Navigator still doesn’t list the table you need, use the connector’s Advanced options to paste an SQL statement (for example, SELECT * FROM SCHEMA.TABLE) as described in the Power Query HANA connector docs: Power Query SAP HANA connector.For the ODBC refresh failure, is your ODBC source referencing a system DSN? If so, the DSN will need to be made on the server hosting the Power BI Report server as well as on your machine.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.
Hi vyask ,
Thank you for reaching out to the Microsoft Community Forum.
Hi tayloramy , Thank you for your prompt response.
Hi vyask , In addition to tayloramy response, i have added some more points.
Please try below things to fix the issue.
1. Refresh Data in Power BI, Check the connection uses Import mode or configure DirectQuery with SSL.
2. HANA Connector Refresh, Works better with DirectQuery. If using relational mode, you can write SQL queries and schedule refreshes.
3. Use relational mode in HANA connector for full flexibility.
4. Use Advanced options to write SQL queries for specific tables.
5. Check user privileges in SAP HANA allow access to the required schemas and tables.
6. For ODBC, configure SSL and validate certificates correctly.
7. Use Import mode if refresh is not critical or if DirectQuery performance is poor.
Please refer below links.
Solved: SAP Hana DB objects are not getting reflected in P... - Microsoft Fabric Community
Solved: Connect Power BI directly to HANA Tables - Microsoft Fabric Community
Solved: How to automatically refresh Power BI report conne... - Microsoft Fabric Community
SAP HANA database connector troubleshooting - Power Query | Microsoft Learn
Configure SSL for ODBC client access to SAP HANA - Power Query | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi vyask ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi @vyask ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
