Forum Discussion

ryanm's avatar
ryanm
New Member
10 years ago
Solved

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

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