Build Scalable BI Solutions Using Power BI and Snowflake

On the Power BI team we want our customers to be successful whichever data source they’re using – not just the Microsoft ones. Recently I had the pleasure of recording a webinar on the subject of best practices for using Power BI with Snowflake, along with Craig Collier from Snowflake and Chris Holliday from Visual BI (a partner that specialises in Power BI/Snowflake solutions). You can watch it here:

There’s a summary of what we talk about on the Snowflake blog:

We’re continuously improving the performance and functionality of all our connectors, and Snowflake is no exception: we recently announced that in early 2021 we’ll have support for Snowflake roles and the ability to use your own SQL queries in DirectQuery mode. Power BI support for Azure Service Tags (on the roadmap here) will also be very useful for Snowflake customers.

3 responses

  1. Great news – but why native queries available only in DirectQuery? Why not import mode?

    And will this mean that query folding works as well? For incremental refresh purposes?

  2. Pingback: New Gateway, Power BI data source management and more… (Roundup | October 19, 2020) – Guy in a Cube – Learn Power BI – Power Platform Resources, News, Tips

  3. Hi Chris. This is timely. Question: Do you have any horror stories about what kinds of needless compute costs that clients were paying by not following the kinds of best practices you cover in this video? And also by relying on blanket DirectQuery over Snowflake instead of taking a managed approach that included aggregations, composite models, and the like?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: