cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Azure Cognitive Services - ResourceAccessForbiddenException

 

I'm trying to utilize Azure Cognitive Services to do some keyphrase/sentiment analysis on some data.  I'm following the tutorial here. 

 

https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi...

 

Generally speaking this is working.  I can connect to cognitive servces and it returns keyphrases/sentiment data.  However as soon as I push "apply changes" I will get the following exception...

 

OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException' was thrown..

 

The error message would seem to indicate that the probem has to do with my datasource, but it's simply a .csv file with 3 columns, 1600 rows located on my desktop computer.  It seems fully related to Azure Cognitive services.  Additionally, I've run into this issue with several other types of data sets, data sources, it only happens when calling azure cognitive services.  It seems like it works on occasion with less data rows (i.e. 400) but chokes on larger datasets?   Anyway, I cant find a working solution anywhere.  Any insights would be appreciated!

 

Mike

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

 

I finally figured it out.  Embarrasingly enough, the reason was that I was using the "Free subscribtion" in azure.  This allows for some limited transactions, which explains why it would work for some datasets then stop working.  As soon as I changed the service to a paid tier, everything worked as expected.

 

 

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi @hawb ,

I don't have such a subscription and can't reproduce your issue. Some references:

1. Do you have any blank columns or rows? Remove them and try it again.

2. I find this post. Please refer to the method and try it again.

 

If the issue is still there and you are a pro user, I suggest you to create a support ticket to get further help.

 

Support Ticket.gif

 

Best Regards,

Icey

 

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

Highlighted
Helper I
Helper I

 

I finally figured it out.  Embarrasingly enough, the reason was that I was using the "Free subscribtion" in azure.  This allows for some limited transactions, which explains why it would work for some datasets then stop working.  As soon as I changed the service to a paid tier, everything worked as expected.

 

 

View solution in original post

Highlighted
Community Support
Community Support

Hi @hawb ,

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

 

Best Regards,

Icey

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors