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.

 

desertislesql's avatar
desertislesql
Most Valuable Professional
10 years ago

That's a very interesting solution. Thanks for sharing. Here's a question, are you able to refresh the data extracted from the datastore in the personal gateway?

 

  • gerardcuijpers's avatar
    gerardcuijpers
    New Member
    10 years ago

    I published the report to PowerBI.com and I could refresh the data there. Don't need the gateway, there's no local to cloud data movement involved here. (Direct connection). I just needed to re-enter my credentials for the DataLake reference.

    • DrGigabit's avatar
      DrGigabit
      Regular Visitor
      9 years ago

      I am getting the followin error, while trying to re-enter the credentials

      Failed to update data source credentials: The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details

      Activity ID:    f3753c07-f1f2-4d8e-b55e-af0a9b0ec4e8
      Request ID:    323a3391-1a49-6c15-3ed8-c0792e4c2610
      Status code:    400
      Time:    Wed Nov 16 2016 13:26:42 GMT+0100 (W. Europe Standard Time)
      Version:    13.0.1700.581
      Cluster URI:    https://wabi-north-europe-redirect.analysis.windows.net
      Details:    The credentials provided for the DataLake source are invalid. (Source at https://xxx.azuredatalakestore.net/yyy.)