Nisal Mihiranga's Blog

Connecting to Data Lake Store via Power BI is become a norm. However though the steps are few, which is really not straight forward as you might need to do some sort of tweaks in order to getting to the data. Recently came across some issue while trying to connect to the Azure Data Lake Gen 2 using Power BI. I used the URL which you can retrieve from Azure Portal or Microsoft Azure Storage Explorer > Properties. I'm not going to explain it the steps in details as it is pretty straight forward and there are many articles on how to do it.  Retrieve the URL from Azure Storage Explorer properties However when I click the OK button to connect, surprisingly I got the error message mentioned in below.  Unable to Connect: Access to the resource is forbidden. Error Message Confusion here is I've logged in using the same account which I used to create the resource. My account has " Owner " role been assigned. Solution  The AD user you used ...

It is almost just less than five days ahead, which I’ve to do a session on Azure Data Lake Analytics at a Big Data Event. When I started to grab the stuff on Azure Data Lake Analytics I could quickly learn few solid points I thought how great if I could share those via a blog post or a video with you all.  Because I observed there are many people get it hard and introduce some complexity when start to work with the Azure Data Lake Analytics. Why Azure Data Lake? Azure Data Lake is cloud-based, distributed processing architecture. Azure Data Lake mainly consist of two components. Azure Data Lake Analytics and the Azure Data Lake Store. Azure Data Lake Analytics : On-demand analytics job service. Rather deploying, configuring and tuning hardware you can more focus on the business need and write queries to generate more valuable insights. Azure Data Lake Store : Web HDFS storage system. Which store your Big Data like structured, semi-structured and unstructured data Azure...