Forum Discussion
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
See the data types supported on this page, specifically the precision allowed for Decimal types.
3 Replies
- Greg_DecklerCommunity Champion
This looks like something that you should use the smiley icon to send a frowny face to support and explain the issue below.
- greggybResident Rockstar
See the data types supported on this page, specifically the precision allowed for Decimal types.
- ryanmNew Member
Thanks Greg! That was exactly what I was looking for.