Conversion overflows exception when attempting to show a DECIMAL(38,34) measure.

[ryanm]

Hi everyone,

I have a Measure that is a DECIMAL(34,30) on the SQL Server side. However, when I try to model this Fact table on the Dashboard I get the following error message (in bold):

The following exception occurred while the managed IDataReader interface was being used: Conversion overflows..

Stack Trace:

 Invocation Stack Trace:

 Activity ID
bc0e1d01-7ba3-1ed4-8e7b-43a150f76c6b

Time
Tue Jan 12 2016 15:11:58 GMT+0000 (GMT Standard Time)

Version
2.30.4246.281 (PBIDesktop)

This same measure worked when it was a DECIMAL(18,2) on the SQL Server side. I'm guessing Power BI Desktop can't handle a DECIMAL with so many decimal points. Any help on how I can present this Measure on a Dashboard would be greatly appreciated.

Cheers

Ryan

[Greg_Deckler]

This looks like something that you should use the smiley icon to send a frowny face to support and explain the issue below.

[greggyb · Accepted solution]

See the data types supported on this page, specifically the precision allowed for Decimal types.

[ryanm]

Thanks Greg! That was exactly what I was looking for.