Use text analytics with key phrase get ODBC error

[Thibaut-J]

Hi Community,

I'm trying to load a dataset of 500k records to analyze activity notes with text analytics and key phrases but get the error below:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'Unable to read data from the transport connection: The connection was closed.'. '.

I tried to split the queries by batch of 50k records, reduce the number of paralell execution, updating the Power BI version, ... with no chance.

Could you please help?

Thanks a lot in advance.

[rajendraongole1]

Hi @Thibaut-J - It s a connection was closed issue, typically indicates issues with data transfer or connectivity when loading large datasets in Power BI. 

ensure it is set to a level that your machine and data source can handle.Check the quota and rate limits of your Azure Cognitive Services resource.

still issue exist, try to extract the data from dataflow from power bi services,Go to the Power BI service and navigate to the workspace where you want to create the dataflow.Select Create > Dataflow.Add a new table and import your data in smaller batches.

Reference:

What is Azure AI Language - Azure AI services | Microsoft Learn

Solved: Unable to read data from the transport connection ... - Microsoft Fabric Community

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!