search

CreativeDataEU / PowerBITrinoConnector

A Micosoft Power BI Custom Connector allowing you to import Trino data into Power BI.
MIT License
50 stars 15 forks source link

Get data based on date filter #8

Closed icarocleto closed 10 months ago

icarocleto commented 1 year ago

First, thanks for the connector, it's working great.

Every time I update the dataset, the connector takes data from the entire database. As my base is growing, this process is getting slower.

I would like to use Power BI's ability to update data incrementally, taking what was added or updated on a specific date range. Is there any way in this connector to configure conditionals to bring filtered records into the query?

pichlerpa commented 1 year ago

Hi @icarocleto, yes, it should be technically possible to include this functionality in the connector like in this blog post: https://www.thepoweruser.com/2018/05/08/first-thoughts-on-power-bi-incremental-refresh

Regards, Patrick