Question
I have several questions to discuss regarding the connector:
-
To improve the query response time, is there a possibility that the URLs can enforce filters on the local data?
-
Current query folding limitations.
Answer
Our Power BI connector uses OData and offers partial query folding in Power Query. Currently, the "$top" operator is supported for all queries, while the "$filter" operator is supported only for incremental refresh. You can find detailed setup instructions in our incremental refresh documentation at https://help.tempo.io/powerbiconnector/latest/setting-up-incremental-refresh
For general data filtering, we recommend applying filters directly within the data source.