Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Storage Capability for Power BI

I am creating a report for manufaacturing industry. Every day we get lot of order quantity based on the products. The details are maintained in SAP Hana DB.   Example:- We got a order for making 10...
Need Help
Show and Tell
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, Anonymous 

 

Here are supported features for SAP HANA:

  • The Power BI connector for SAP HANA uses the SAP ODBC driver to provide the best user experience.

  • SAP HANA supports both DirectQuery and Import options.

  • Power BI supports HANA information models, such as Analytic and Calculation Views, and has optimized navigation.

  • With SAP HANA, you can also use the direct SQL feature to connect to Row and Column Tables.

  • Power BI includes Optimized Navigation for HANA Models.

  • Power BI supports SAP HANA Variables and Input parameters.

  • Power BI supports HDI-container-based Calculation Views.

 

I'd like to suggest you import data from SAP HANA DB and publish it to Power BI Service. Then you can set the interval for schedual refresh  as an hour.

 

For further information, you may refer to the following document.

Connect to SAP HANA databases in Power BI 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.