Session resources: Power BI dataflows and Azure Data Lake integration

Last week I delivered two online sessions on the topic of integrating Power BI dataflows with an organizational Azure Data Lake Storage Gen2 storage account. I’ve blogged on this topic before (link | link | link | link) but sometimes a presentation and demo is worth a thousand words.

On April 30th I delivered a “Power BI dataflows 201 – beyond the basics” session for the PASS Business Intelligence Virtual Chapter. The session recording is online here, and you can download the slides here.

On May 4th I delivered a “Integrating Power BI and Azure Data Lake with dataflows and CDM Folders” session for the SQL Saturday community event in Stockholm, Sweden. I was originally planning to deliver the Stockholm session in person, but due to circumstances beyond my control[1] I ended up presenting remotely, which meant that I could more easily record the session. The session recording is online here, and you can download the slides here.

Each of these sessions covers much of the same material. The Stockholm presentation got off to a bit rocky start[2] but it gets smoother after the first few minutes.

Please feel free to use these slides for your own presentations if they’re useful. And please let me know if you have any questions!

[1] I forgot to book flights. Seriously, I thought I had booked flights in February when I committed to speaking, and by the time I realized that I had not booked them, they were way out of my budget. This was not my finest hour.

[2] The presentation was scheduled to start at 6:00 AM, so I got up at 4:00 and came into the office to review and prepare. Instead I spent the 90 minutes before the session start time fighting with PC issues and got everything working less than a minute before 6:00. I can’t remember ever coming in quite this hot…

5 thoughts on “Session resources: Power BI dataflows and Azure Data Lake integration

  1. Hi Mattheu
    have you been able to use Dataflow + Data Lake Gen2 with a Pro account?

    If I access an on-premises table (via gateway), I receive an error with the message that is a Premium requirement, when trying to refresh the dataflow.

    Now if I connect to an Azure SQL Database I get an error that the credentials are missing …

    best regard

    I like heavy metal but I prefer punk rock 🙂


    1. This sounds unrelated to Pro vs. Premium. I am able to successfully use (and access) dataflows backed by an ADLSg2 storage account in a workspace in shared (Pro, non Premium) capacity.


  2. Matthew:

    Once again, a great presentation. I would love to see more about ingesting Dataflows in SQL Server technologies. I would also like to know if U-SQL is being replaced or supplemented with a technology that will also work with Dataflows and CDM.

    Thank you again!

    Darryll Petrancuri


    1. Thanks Darryl!

      Different Azure services (including SQL DW, and I assume SQL DB) are working on CDM Folder integration that makes sense for their services’ capabilities and the scenarios they support. Since this is my personal blog (and since they own their own roadmaps 😉 ) I can’t comment on anything that hasn’t been publicly announced, but I’ll share what information I can, when I can.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s