Forum Discussion
Direct Query performance issue
Hi Everyone, I'm currently utilizing Direct Query Mode in Power BI for our dashboards. However, we're experiencing performance issues with SAP when multiple users are accessing the reports simultane...
anupamj
Helper II
Helper IIHi Anonymous , did you consider caching the data in a repository (ADLS / Onelake/ others)?
- Microsoft recommended architecture for PowerBI / Fabric integration with SAP (See the cached method):
- PowerBI can schedule the refreshes from SAP as per this guide: https://youtu.be/TA0-tya44K0
Questions? please reach out.
Anupam