Forum Discussion

hubix2000's avatar
hubix2000
New Member
10 years ago

PowerBI with Azure Data Lake Store

Hi,   we already run all our operations on Azure SQL databases. Now we are going to invest into Azure Data Lake Store and like to integrate it with PowerBI. Currently there is no external data sour...
gerardcuijpers's avatar
gerardcuijpers
New Member
10 years ago

I managed to get data from a Data Late Store into PowerBI desktop, but not the way I would like it:

  • PowerBI Desktop, Version: 2.32.4307.641 64-bit (February 2016)
  • Get Data / Azure / Microsoft Azure Data Lake Store (Beta)
  • Provide the adl:// or swebhdfs:// path
  • It will show you a preview with columns like "content, name, extension, .."
  • Click on "Edit"
  • Click on the link "Binary" in the first column ("Content")
  • Now you can see the the data as it appears in the file itself.

 

shabbirmala's avatar
shabbirmala
Frequent Visitor
9 years ago

What happens when we have files stored in multiple sub folders by timestamp?

 

When I browse binary data and check the scripts inside Power BI advance editor I get follow:

 

let
Source = DataLake.Contents("https://xxxxxxxx.azuredatalakestore.net"),
Content = Source[Content],
Content1 = Content{0},
#"2017" = Content1{[Name="2017"]}[Content],
#"04" = #"2017"{[Name="04"]}[Content],
#"20" = #"04"{[Name="20"]}[Content],
#"14_0_f44e6b5c95fa49dfa3b78c89878777d1 json" = #"20"{[Name="14_0_f44e6b5c95fa49dfa3b78c89878777d1.json"]}[Content],
#"Imported CSV" = Csv.Document(#"14_0_f44e6b5c95fa49dfa3b78c89878777d1 json",[Delimiter=",", Columns=17, Encoding=1252, QuoteStyle=QuoteStyle.None]),

 

which tells I went all the way to 2017-04-20 and picked that day file. 

 

Can I setup this to load all files as they come?

 

Shabbir