Benchmark: TDS Endpoint vs QueryExpression vs FetchExpression
In the blog post, Mark Carrington explores the TDS Endpoint revisited, focusing on the internal Dataverse message, ExecutePowerBISql, and comparing it to a Custom API created for similar purposes. The post delves into using the TDS Endpoint Plugin and the logic behind its implementation. A custom API with pagination and token handling is demonstrated. The performance of ExecutePowerBISql is benchmarked against a Custom API, showcasing its ability to handle SQL queries efficiently. Additionally, comparisons using FetchExpression and QueryExpression are discussed to evaluate their effectiveness. Various methods and settings involved in implementing these endpoints are detailed, providing insights into optimizing Dataverse interactions through tailored plugins and APIs.
Article 2m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time