Native SQL Query

Sometime back I was working on a requirement to extract millions of records from a datawarehouse system for Power BI reporting. I was using native SQL query with multiple table joins and where clauses. As the records were in millions, implementing incremental refresh was the best choice to avoid reloading the entire data on every […]