Why do i recieve the following error when performing a Close and Apply? OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenException' was thrown..

Nick McDaniel 1 Reputation point
2021-09-27T16:59:04.367+00:00

I'm using Microsoft's 30 day Trial for Azure, mainly to see if Text Analytics will work for my company.

I created an Invoke Function with the code required to call and return Key Phrases. From Add Column, I select Invoke Custom Function, select my custom function and the field I want processed. Power Query then inserts a new column with the Key Phrases (all looks good). When I select the option to Close and Apply I receive the following error message.

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

As one of the suggested solutions on the forum; I cleared the Global Permission from Data Source Setting. I'm still receiving the same error.

Can anyone assist with how best to resolve my issue?

Thanks.

Nick

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
27,033 questions
Cognitive Service for Language
Cognitive Service for Language
An Azure service that provides natural language capabilities including sentiment analysis, entity extraction, and automated question answering.
217 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ehren (MSFT) 1,776 Reputation points Microsoft Employee
    2021-10-01T18:58:57.297+00:00

    Hi there. Power Query is no longer supported here on Q&A. I'd recommend you post this over on the https://aka.ms/PQCommunity site.

    0 comments No comments