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.

[Elxy]

I've been looking through Google for solutions as well and even hopped on to YouTube for tutorials. My understanding about the issue so far is only that access to the imported file in Power Query Editor that I wanted to apply to Power BI Desktop is forbidden... 

So after doing sentiment analysis and getting the document and confidence scores, I just copied the ENTIRE table and pasted it in a blank Microsoft Excel Workbook. I saved it, open a new Power BI Desktop and imported that file instead. The sentiment analysis stayed there, so I didn't need to create a query anymore and can immediately use the data to start visualising!

In a nutshell, just copy whatever you have, paste it in Microsoft Excel and save it, then just use that file going forward. Hope this helps!

[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.