I am doing text analytics using Microsoft Cognitive Service. I created a custom function following this tutorial. https://docs.microsoft.com/en-gb/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi...
When I use apply & close I get the error "OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenEx"
I cannot seem to find the issue. Any help would be appreciated.
The error stopped happening for us when we switched from the free trial Azure subscription to paid subscription. That may have been a coincidence of timing, but since it's no longer happening, there's nothing for support to investigate.
I am getting the same error when using Azure Text analytics from PowerBI. Oddly enough, the custom function for key phrases was working, but when I added a custom function for sentiment (analyzing the same data column), I now receive the "OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Enginer.Interface.ResourceAccessForbiddenException'
It's a strange error because in the Data Editor preview window I can see that the sentiment column built using the custom function initially returned numeric values, but the full data refresh throws the error. Any suggestions? As far as I can see, the keyphrases and sentiments custom functions both have the same data source and permissions settings.
I have checked the Azure portal and determined that this is not a current connection issue. I can see in the activity log that I successfully connected to the data source, but the data refesh will not complete and instead throws the error message above.
Here is a similar post for you refer to:
Click File->Options and settings->Data source settings->Global permissions
Then select the permission and clear permission.
Click here to learn more about the August 2022 updates!
Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.