How to use azure data lake store gen1 source in dataflow?

[Anonymous]

Hi everyone,

I have a CSV file stored in azure data lake store gen1 which I would like to use in a Power BI service dataflow.

The query to the CSV file works fine in Power BI desktop.

I've tried to do following steps:

- Create a dataflow

- Define a new entity

- Use "Emtpy query" as data source

- Copy over the first line in power query from desktop into online editor:

let
Source = DataLake.Contents("adl://xx.azuredatalakestore.net/xx...csv")
in
Source

- Then the online editor request to configure the connection, I start the dialog

- I select "organizational account" (the dialog shows "You're logged in")

Observations:
- Online editor shows a warning "query contains 1 errors" on bottom left, but not the issue. the editor still request to configure the connection.

- The connection dialog shows a URI 'Datalake: https://xx.azuredatalakestore.net/xx...csv' instead of the URI used in power query 'DataLake.Contents("adl://xx.azuredatalakestore.net/xx...csv")'

- I've also tried to "login with another user", but no change in result.

--> Does anybody know how to use azure data lake store gen1 in dataflows?
 

Best regards,

Thomas

[Anonymous]

Hi @Anonymous ,

Please check the document below and see if it helps.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Jay,

the linked document only mentions how to do this for Gen 2 data lake. My data lake if of Gen One.

I also tried out providing my Gen1 URI to Gen2 connector but this didn't worked.

So this does not solve my issue.

Best regards,

Thomas

[IfYouBuildIt]

Hi Thomas,

Did you ever find a solution for this? I'm running into the same problem.

Thanks!

[Anonymous]

Hi,

no. We've moved to Azure SQL Database as data source for Power BI reports. CSV files also have generally very low performance.

Best regards,

Thomas