Skip to main content

Error When Connecting to Azure Data Lake Storage Gen2 using Power BI : Unable to Connect: Access to the resource is forbidden

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 in Power BI to connect to the Azure Data Lake, Storage Blog Data Reader permission has to be given, in order to read the data in ADL.


This approach worked very well to sort this problem I mentioned above. 

Labels:

Comments

  1. Synsoft GlobalDecember 7, 2019 at 5:59 AM

    Nice blog.
    The way you explained about the setting of Http with Nginx on azure is brilliant.
    The way you described the details in the blog is very easy to understand and is very important too.
    I was looking for azure develops company for my software development related requirement and got your blog.
    Thanks for sharing such a great blog.
    Hire Dedicated Website Development Company

    ReplyDelete
  2. Krishna OptifJanuary 27, 2020 at 9:51 PM

    very nice and provide me informative content thanks for sharing for more information Looking for the best Importance of business intelligence

    ReplyDelete
  3. bharath2121.abtrainingsMarch 11, 2020 at 6:38 AM

    very nice post thanks for sharing
    Power BI Training online

    ReplyDelete
  4. UnknownApril 20, 2020 at 4:07 PM

    Thank you so much, been struggling with this problem for day and you really help me.

    Thank you for sharing

    ReplyDelete
  5. isabella wilsonApril 26, 2020 at 5:12 AM

    Thanks for sharing such beautiful info , i think u will also share such type of info ,
    i am very happy to that your way of consideration is very much good , i liked it ,
    can u share again such type of info??? ... " Self Storage "also one of the out standing SELF storage Copany in Uk ,
    Cheapness with best quality is the reason are that every person most prefer to get their services ...
    For more detail click here

    ReplyDelete
  6. James ZicrovMay 26, 2020 at 2:33 AM

    I think there is a need to provide some more information and explore more resources of Power BI as well.

    Powerbi Read Rest

    ReplyDelete

Post a Comment

Popular posts from this blog

Step-by-Step Twitter Sentiment Analysis Using Power BI Streaming Dataset, Microsoft Flow and Azure Text API

Sentiment Analysis is known as Opinion mining or emotion AI which is a branch of Natural Language Processing and text analytics where systematically identify, extract, quantify, and study affective states and subjective information. This kind a analysis widely apply to analyse the product or service reviews, voice of the customer, survey responses from online and social media feeds to analyze the attitude of the customer. Basically from the sentiment analysis the output would be either Positive, Negative or Neutral.  There are various algorithms and methods to do a sentiment analysis out there. In this post here I'm doing a sentiment analysis for iPhone 8 product by analyzing twitter feeds. Because, I wanted to know what others are thinking about the latest phone released by Apple. In order to do this task I'm using,  Microsoft Azure cognitive services : Text Analytics (to run the sentiment analysis algorithms to get out the results)  Microsoft Flow ...
5 comments
Read more

How to Get Row Counts for all Tables in your SQL Database

This is the simplest method to get the row counts of all tables in your SQL Server database. Might be useful when you are doing the data testing over your BI project.     select   schema_name (tab.schema_id) , tab.name  as  [table],         sum (part.rows)  as  [rows]     from  sys.tables  as  tab          inner join  sys.partitions  as  part              on  tab.object_id  =  part.object_id where  part.index_id  IN  ( 1 ,  0 )  //   0 :  Table   without  PK,  1 :  table   with  PK and   schema_name (tab.schema_id)  =   'dbo'   group by   schema_name (tab.schema_id) , tab.name --order by sum(part.rows) desc  
Post a Comment
Read more

COVID-19 Situation in Sri Lanka: Real-time Dashboard using Power BI

[Updated on March 28, 2020] COVID-19  is a new strain that was discovered in late December, 2019 and by now it has been started to spread all over the world including 199 countries. There are around 26,000 people were died due to the virus and 580,000 confirmed cases at the moment I update this blog post. Though, the fatality rate is lower when compared to other viruses in similar strains like MERS and SARS . However, the biggest challenge most of the countries facing right now is to accommodate the patients with the growing numbers at every minute. The public was asked by the government to avoid nonessential gatherings as much as possible to stop spreading this deadly virus. Even though there were not many cases found in Sri Lanka, from March first week, they found the initial case a patient who works as a tourist. Now the situation is turning to worst after they found many cases especially tourists who are born Sri Lankans came down from Italy and European countries....
4 comments
Read more