How do I connect Power BI with SAP BW without performance issues?
I need to create Power BI reports based on data from SAP BW, ensuring that the integration does not introduce significant performance lags. The connection should allow for efficient querying and minimal data refresh delays. What are the most effective methods or connectors—such as the SAP BW Open Hub, OData feeds, or Power BI native connectors—for achieving a smooth and reliable integration?