topic Re: SAP Tables Data in PBRS in Report Server

SAP Tables Data in PBRS

vyask — Sat, 13 Sep 2025 07:30:02 GMT

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?

Re: SAP Tables Data in PBRS

tayloramy — Sat, 13 Sep 2025 16:51:27 GMT

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.

Re: SAP Tables Data in PBRS

v-dineshya — Mon, 15 Sep 2025 09:57:41 GMT

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

Re: SAP Tables Data in PBRS

v-dineshya — Mon, 22 Sep 2025 06:36:54 GMT

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

Re: SAP Tables Data in PBRS

v-dineshya — Thu, 25 Sep 2025 15:19:05 GMT

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

Re: SAP Tables Data in PBRS

v-dineshya — Mon, 29 Sep 2025 04:35:01 GMT

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