Forum Discussion
Direct Query performance issue
Super UserHi Anonymous
Several things to consider:
- Is direct query necessary? You might just need a combination of import and direct query (composite) or just plain old import.
- Look into user-defned aggregations (aggregation table).
- This one is very important: Where in SAP is the report getting data from? it shouldn't be from the same database the operation/production is using but from a data warehouse or a database replica.
Hi ,
Thanks for the response.
I'm using the SQL statement to fetch data for 2 years from SAP PRD Database in direct query mode, and we are using the PowerBI Pro license.
The Power BI Dashboard is shared with more than 150+ users, and the SAP Database is getting slow when users access the single report on the same day.
I cannot use the import mode because the data I'm fetching has more than 20 lacs of records for two years, and it takes time to load the data.
How to resolve the issue?
- danextian
Hi Anonymous ,
It isn't advisable to be querying the same database the production is using. It is a best practice to use a replica or a data warehouse.
anupamjHelper II
Hi danextian, ref to the advice "It isn't advisable to be querying the same database the production is using. It is a best practice to use a replica or a data warehouse."
This used to be best practice a few years ago, but SAP (& many other applications) are now merging OLTP & OLAP engines, driving towards embedded intelligence.
HANA is the platform for inbuilt intelligence within the transaction engine & even Fabric / PowerBI support realtime queries with SAP.