odbc

3 Topics

ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.
Hi All, I'm wondering if someone can help me with this issue. I have set daily refresh on my report and it's been working fine for the past 5-6months, until this week I recieved scheduled refresh failure notice with the error message : ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value. I have four tables in this report and all are coming from snowflake which all are using the same date source. For trouble shooting I created four reports each contain on of the four tables and refresh the data. Only one table is giving me trouble, but how is this possible if all tables are using the same dates? I have also tried refreshing the report with powerbi desktop and it gives me no issues. Does that mean the issue is not within the dataset but from powerbi server? Sometimes if I refresh the report multiple times it will succeed but most of the time it's giving me the same error message. Is there a way of ignoring the ODBC error since I'm confident that all my date values are valid?
Solved
Anonymous
4 years ago Place Service
20KViews
6likes
18Comments
Password protected Access Database - Gateway error
Hi all, I am fairly new to Power BI. I have an access database which is password protected. From my Power BI Desktop, I am able to successfully connect to it through OLE DB driver (Thanks to reference). Now, I have published the report online and trying to schedule a refresh for this database through an on-premises gateway (reference) located in the server. I tried choosing couple of Authentication Methods and still hitting the following roadblocks. Windows - OLEDB driver does not support this authentication method Anonymous Any leads would be appreciated, thanks in advance.
Solved
rsangeetha
4 years ago Place Service
2KViews
0likes
3Comments
Data Source Credentials Option Greyed Out for ODBC Connection (Denodo)
Hi Community, I am using 32 bit ODBC DSN to Connect Report builder to Denodo. I have Created Paginated Report using Configured 32 bit ODBC DSN and Report is working fine in Report Builder but when i published same report, it is not working in Power BI Service. "Unable to render paginated report A data source used by this report returned an error. An exception encountered while accessing the target data source ERROR [08001] ERROR: SSL connection required ERROR: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. DETAIL: java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version." Also Data source Credentials option got grayed out. what is the possibe reason and how can i resolve the issue? Thanks, Pravin
Solved
Anonymous
5 years ago Place Service
5.5KViews
0likes
4Comments