An error occurred while processing the data in the dataset.

Wang, Shiyu 0

3月20日，我在BI关联数据Salesforce系统里更新了Project_ID属性为Text（更新之前是数字属性），3月21日出现数据更新失败的情况。想问下是不是因为属性更改的原因导致的数据更新失败。

Subashri Vasudevan 11,206 Reputation points

2023-03-21T05:02:43.8866667+00:00

Hi @Shiyu Wang

Request you to kindly translate your question in English and provide more details about the activity that uses the data set. Regards.
Wang, Shiyu 0 Reputation points

2023-03-21T06:28:01.7333333+00:00

I changed the property of "Project_ID" from number to text in the raw data system. Then I received auto-refresh failed information this morning which can be found in the attachment.

I want to know why here is this kind of failure. and how to solve it.
Wang, Shiyu 0 Reputation points

2023-03-21T06:28:10.81+00:00

Here mentioned data type VT_R8, does that mean number?
ShaktiSingh-MSFT 14,906 Reputation points

2023-03-21T06:32:57.0633333+00:00
Hi @Wang, Shiyu ,

Welcome to Microsoft Q&A forum.

We need more details from you to help.

At what step you got above screenshot?

What operation are you doing in Azure SQL Database?

Does this involve other services too?

Share sample data and steps so that we can reproduce and check.

Thank you.
ShaktiSingh-MSFT 14,906 Reputation points

2023-03-23T05:34:32.91+00:00

Hi @Wang, Shiyu ,

Could you please provide more information as mentioned in the above comment. Thanks

Your answer