Skip to main content

    Power BI

    Needs Votes

    Support for Delta Lake directly from Azure BLOB and other storage types

    Vote (14) Share
    Wesley Backelant's profile image

    Wesley Backelant on 07 Jun 2021 11:47:04

    It would be great to have native support in Power BI for Delta Lake as that could make it easier to import data without passing through other components.

    Comments (2)
    Wesley Backelant's profile image Profile Picture

    Greg Lowe on 26 Aug 2021 20:19:25

    RE: Support for Delta Lake directly from Azure BLOB and other storage types

    This would be an excellent addition. We are building delta lake tables with ADF. In order to read these tables into a dataflow we need to build views in Azure Synapse. This just adds extra layers, permissions and costs. Going directly to the table would be prefered.

    Wesley Backelant's profile image Profile Picture

    Gene Garcia on 07 Jul 2021 13:23:42

    RE: Support for Delta Lake directly from Azure BLOB and other storage types

    This can be done through sql serverless - here's the info: https://techcommunity.microsoft.com/t5/azure-synapse-analytics/query-delta-lake-files-using-t-sql-language-in-azure-synapse/ba-p/2388398

    Once you have a view or external table setup, you connect from PowerBI using the Azure SQL database connector (pointing to the serverless SQL endpoint of your Synapse workspace).