Forum Discussion

diegoadum's avatar
diegoadum
Icon for Helper I rankHelper I
5 years ago

Read Approvals and Approval Request tables

Hi Folks,

 

              I'm trying to read the Approvals and Approval Request tables using Power Bi, but I'm getting the below error message.

 

 

Here's the completed error message:

 

DataSource.Error: Microsoft SQL: Adding a value to a 'datetime' column caused an overflow.
RequestId: TDS;0fb7c282-c2ed-485c-aa9e-14cdad79349b;2
Time: 2021-04-05T14:12:27.3140958Z
Detalles:
DataSourceKind=CommonDataService
DataSourcePath=XXXXXXXXXXX.crm.dynamics.com
Message=Adding a value to a 'datetime' column caused an overflow.
RequestId: TDS;0fb7c282-c2ed-485c-aa9e-14cdad79349b;2
Time: 2021-04-05T14:12:27.3140958Z
ErrorCode=-2146232060
Number=40000
Class=16

 

it's worth mention that I'm getting the same error for the Approval Request table as well, but I can read the Approval Response table.

 

I don't know if there is a way to read the tables using "normal" SQL sentences, on where I can pick only a few fields and avoid the error with the date? 

 

Thank in advance for any idea!!

2 Replies