Forum Discussion

otravers's avatar
otravers
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

Azure Datalake Storage Gen2 DFS Endpoint: supported in Power BI Dataflow?

I'm using the following M code to connect to an ADLS Gen2 blob container where I have content created by a Power BI dataflow:

 

= AzureStorage.DataLake(#"https://xxxxxx.dfs.core.windows.net/")

 

This works in Power BI Desktop, but when I copy that code to a new dataflow, I get "Connection could not be created" after signing it via the proper organizational account. Is ADLS Gen2 storage supported in dataflows? It's not listed in the Get Data UI, but there's always been stuff that works in dataflows without UI support.

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support

    Hi otravers ,

     

    Based on this document, the data source of Azure Datelake Storage Gen2 is not listed in the supported source list of blank query. If you want to connect the content in ADLS, you can Add a CDM folder to Power BI as a dataflow based on this document: https://docs.microsoft.com/en-us/power-bi/service-dataflows-add-cdm-folder

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.