将简单的XML导入Power BI

我正在尝试将此简单XML数据导入Power BI(或Excel 2016):

https://resourcescrono.s3-eu-west-1.amazonaws.com/demo-biblio.xml

这是一个简单的XML,带有3列表(甚至附加了XSD模式)。可以在以前的Excel版本(Excel 2003等)中轻松导入相同的XML。

但是,Power BI和Excel 2016以多种方式失败:

  • 似乎忽略了架构数据
  • 它无法检测不变的数字格式。

如何将这些数据导入Power BI仪表板或Excel 2016?

Power BI屏幕截图

我的区域设置是西班牙语,但我不知道我的用户的区域设置(可能有所不同)。

UPDATE: Microsoft has accepted it as a bug. Excel should respect XSD schema: https://community.powerbi.com/t5/Issues/Bug-importing-simple-XML-file/idc-p/429822

Alejandro Lopez-Lago - MSFT

The number conversion issue comes from the Table.TransformColumnTypes call. Power Query will try to parse the number using the workbook/pbix's locale settings. Therefore, it tries to parse a number like "83647.49" using a Spanish locale, and since (Spanish/International) Spanish uses commas as the decimal separator, the number will be read as an oddly-formatted representation of "8364749".

The locale settings travel with the workbook/pbix, and you can set it in the Options dialog under Current Workbook | Regional Settings in Excel, and Current File | Regional Settings in PowerBI Desktop.

我认为我们不支持noNamepsaceSchemaLocation,但是如果您希望获得支持,请在Power BI Ideas网站上提出建议

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

TOP 榜单

热门标签

归档