处理成功，但部署元数据失败 [英] Processing succeed but deploying metadata failed

问题描述

大家好，

我有一个生产中的Azure分析服务，可以从DataLake Store中存储的CSV中获取数据.

I have an Azure analysis Services in Production which get datas from CSV stored in DataLake Store. 

我最近做了一些更改，我忘记了更改两列的类型(转换为十进制)，即使处理成功，在这两列上部署元数据也失败了.

I recently do some changes, I forgot to change the types of two columns (cast to decimal) even though processing is succeeded, deploying metadata failed on these two columns. 

我得到的错误是:

发生以下系统错误:输入不匹配项.
[表:'Fastbox'，列:'GC_SW_ITS'，值:'null']的数据类型转换失败.

我有空值(我认为Power Query可以将空值转换为十进制)，然后我将空值替换为空白，但结果是相同的.

I had null values (I thought Power Query was able to cast null value as decimal) and then I replace null values by blank but the result is the same..

就像在部署元数据时，它会检查旧条目...?

It's like when it's deploying metadata, it checks old entries... ?

有人知道部署元数据"背后的含义是什么. ?它检查什么?以及存放在哪里?我发现它存储在BLOB存储中，但找不到位置.

Someone knows what is behind the "Deploy metadata" ? What it checks ? and where is stored ? I found it's stored on BLOB storage but can't find where.  

谢谢您的帮助，

此致

Valentin

推荐答案

嗨Valentin，

您将不得不更改列的数据类型以克服此错误.

Hi Valentin,

You will have to change the data types of the columns to overcome this error. 

这里也有类似的问题报道:

https://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/1535e14e-f4e7-454d-a801-64cbd05710bc/power-pivot-data-type-error?forum=sqlkjpowerpivotforexcel

这可以帮助您更改数据类型，然后重新处理数据.

There's a similar issue reported here :

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1535e14e-f4e7-454d-a801-64cbd05710bc/power-pivot-data-type-error?forum=sqlkjpowerpivotforexcel

This might help you change the data type and then re-process the data. 

让我们知道它是否对您有用.

Let us know if it works for you.

这篇关于处理成功，但部署元数据失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！