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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
vyask
New Member

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?

2 REPLIES 2
v-dineshya
Community Support
Community Support

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

 

tayloramy
Solution Sage
Solution Sage

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.

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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