Forum Discussion

grittoa's avatar
grittoa
New Member
9 years ago

Data source error when importing data from Access

Hi, when I import table data from an Access database (17 columns, 184 rows), one of the columns shows all values as error. I am then presented with this error in the Query Editor:   DataSource.Erro...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi grittoa,

 

Based on my test, calculated fields in Access databased can be displayed correctly after being imported into Power BI.

 

To the error message, 'the Decimal data value overflowed the type specified for the Decimal value part in the consumer's buffer', it seems that the actual values didn't match the decimal data type supported by Power BI. As is stated in this article, the Decimal Number type can handle negative values from -1.79E +308 through -2.23E -308, 0, and positive values from 2.23E -308 through 1.79E + 308. The largest value that can be represented in a Decimal Number type is 15 digits long. So, please check the data values in Access database.

 

Besides, the error points out conversion failure, in query editors, under the applied steps, delete the "Changed Type" step to see whether issue persists.

 

For more analysis, please share your source data.

 

Best regards,
Yuliana Gu

grittoa's avatar
grittoa
New Member
9 years ago

Thank you to those who replied. I am no longer going to use Power BI for this initiative and have not progressed trobleshooting this issue. 

  • seanrm42's avatar
    seanrm42
    Frequent Visitor
    9 years ago

    I am also having this same issue. Access is rounding my numbers so there are no more than 2 decimal points but I am getting the same

     

    "DataSource.Error: An error happened while reading data from the provider: 'Conversion failed because the Decimal data value overflowed the type specified for the Decimal value part in the consumer's buffer."