Microsoft Power BI: Latest Release Enhances Connection to Vertica

Posted November 12, 2018 by Kathy Taylor, Information Technology Developer, Vertica

We are excited to announce the new Vertica connector introduced in the October 2018 release of Microsoft Power BI:

• With PowerBI Desktop, Vertica is now fully supported using DirectQuery Mode (push-down optimization).

• With Power BI Service (Cloud Offering – Saas), DirectQuery mode is now supported with Vertica using the Power BI On-Premises Gateway. This lets you:

    • Create DirectQuery-based reports in Power BI Desktop and publish them to Power BI Service.

    • Share the DirectQuery-based reports published in Power BI Service with other users.

When you use DirectQuery, the queries triggered by the report are executed in the database—leveraging Vertica’s speed and support for big data. The connector also supports import mode, which uses cached data for reports. Import-based reports require periodic refresh and do not leverage the processing power of Vertica.

For details, see Vertica Integration with Microsoft Power BI: Connection Guide.