PowerQuery ODBC连接-DATASOURCE.ERROR:十进制值超出范围-SQL查询
我通过PowerQuery创建了ODBC连接。值列导致以下错误:
DataSource.Error:ODBC驱动程序返回了X列的小数值,我们无法理解或不超出范围。
当数据直接加载到PowerQuery时,似乎错误是由大约0的值引起的,而该错误的数量超过6个小数。如果我将连接直接加载到Excel表,则没有错误。
我正在使用的SQL代码只是选择具有几个条件的所需列(从哪里选择)。我还不喜欢SQL。
是否可以直接在查询中的选定值列应用于某种格式或舍入,以便在加载到PowerQuery之前能够读取数据的格式,以便将数据转换为PowerQuery?
还是其他可能解决此错误的解决方案?
任何输入都将不胜感激。
谢谢。
I created a ODBC connection through PowerQuery. The value column is causing the following error:
DataSource.Error: The ODBC driver returned a decimal value for column X, that we couldn't understand or is out of range.
It seems that the errors are caused mostly by values of around 0 with more than 6 decimal when the data is loaded directly to PowerQuery. If I load the connection directly to an excel table, there are no errors.
The SQL code I am using is simply selecting the desired columns with couple of conditions (SELECT, FROM, WHERE). I am not adept with SQL yet.
Is there a some kind of Format or Rounding I can apply to the selected value column directly in the query so that the data is transformed in a format that PowerQuery is able to read before being loaded to PowerQuery?
Or any other possible solutions to fix this error?
Any input is appreciated.
Thank you.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论