pradeep_singh
Honored Contributor III

You can ingest and upsert changes from your SQLite file into Delta tables on Databricks on a schedule (or event-driven if possible). Then connect Power BI to those Delta tables via a Databricks SQL Warehouse using DirectQuery. Power BI will query Databricks at interaction/refresh time so users see the latest data without manual CSV steps.

 

Thank You
Pradeep Singh - https://www.linkedin.com/in/dbxdev