OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenEx

[Anonymous]

Hi,

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.

[JezzaI]

This probably isn't your problem, but as I was silly enough to google the same error, will leave this here for others: I was getting the error as the data source had a firewall between me and it - had to use VPN to get through.

[jackie_tejwani]

Has anyone got this working yet? Nothing works for me

[braypa]

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.

[braypa]

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.  

[v-lili6-msft]

hi, @Anonymous 

Here is a similar post for you refer to:

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-Error-Exception-of-Type/td-p/635036

Best Regards,

Lin

[Anonymous]

Hi,

Thanks for the reply. Could you please let me know how to clear data settings? The post you shared doesnt have that details.

[v-lili6-msft]

hi, @Anonymous 

Click File->Options and settings->Data source settings->Global permissions

Then select the permission and clear permission. 

Best Regards,

Lin

[Anonymous]

Thanks for the reply @v-lili6-msft . I tried that but didn't work. I still get the same error.

[Arjunarao]

Please check these links

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Type-mismatch-Exception-from-HRESULT/m...

https://social.technet.microsoft.com/Forums/en-US/f5ec0578-2a43-4f15-84fd-0e4003d0cfca/ole-db-or-odb...

[Anonymous]

Thanks for the response. So far nothing worked.