This guide explains how to connect Microsoft Power BI to Starburst Enterprise using DirectQuery and ODBC. It outlines prerequisites such as ODBC driver setup and TLS configuration, then details architecture where Starburst acts as a SQL query fabric with Global Access Security enforcing row- and column-level controls. The document highlights DirectQuery as the preferred method for querying terabytes of distributed data in real time without importing into Power BI. It also covers Import mode limitations and Direct ODBC scenarios. The guide emphasizes secure federation across lakes, warehouses, and databases while delivering scalable, high-performance BI reporting.

Join for free to read