Skip to main content
To homepage To homepage

Hi everyone,

 

We are trying to load csv file from Azure Blob Storage or Azure File Share with the guidance according to the posts below. But we are still receiving error: “Exception has been thrown by the target of an invocation.”

Connect to CSV data sources | Community

Load CSV files from Azure Blob Storage | Community

Kindly see the connection details below. Could you help give some advice? Thank you!

 

For Azure Blob Storage

For Azure File Share

 

Hi ​@Xiaoqing Hu can you please try using the TimeXtender CSV data source rather than the Cdata CSV data source? Please see the guide below

In the example below I am connecting to storage account datalakechaug and blob container blobchauggaard

I get the connection string by going to the Azure portal and navigating to my storage account and selecting Access keys

Then I fill out the following settings in the data source

The Azure tenant ID, client ID and client secret are referring to the app registration that has access to the storage account

 

Hi ​@Xiaoqing Hu 

Did you get a chance to try the the TimeXtender CSV data source?

​@Christian Hauggaard  Sorry for the late reply, it works! Thank you very much!

Reply


Terms and ConditionsCookie settings