Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm using Power BI x86 and Microsoft Driver for connecting to IBM DB2 server.
For using connection, I unmarked 2 boxes :
I can use a lot of table without problem.
But with one of them, i have the error above :
DataSource.Error : Microsoft Db2 Client : Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. SQLSTATE=HY000 SQLCODE=-343 Détails : DataSourceKind=DB2 DataSourcePath=MyServer.prod.MyDomain.fr:50000;MyDB Message=Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. SQLSTATE=HY000 SQLCODE=-343 ErrorCode=0
The table structure is this one :
"DATE_KEY" INTEGER NOT NULL , "FSC_DIM_WEEK_NUM" INTEGER , "CAL_DIM_MONTH_NUM" INTEGER , "CAL_DIM_QTR_NUM" INTEGER , "CAL_DIM_YEAR_NUM" INTEGER , "FSC_DIM_QTR_NUM" INTEGER , "FSC_DIM_YEAR_NUM" INTEGER , "CAL_MONTH_DAY_NUM" SMALLINT , "CAL_YEAR_DAY_NUM" SMALLINT , "CAL_DAY_STR" VARCHAR(30) , "CAL_DAY_FLAG" VARCHAR(30) , "CAL_DAY_DT" DATE , "CAL_YEAR_MONTH_NUM" SMALLINT , "CAL_MONTH_STR" VARCHAR(30) , "CAL_MONTH_START_DT" DATE , "CAL_MONTH_END_DT" DATE , "CAL_MONTH_FLAG" VARCHAR(30) , "CAL_MONTH_END_FLAG" CHAR(1) , "CAL_YEAR_QTR_NUM" SMALLINT , "CAL_QTR_STR" VARCHAR(30) , "CAL_QTR_START_DT" DATE , "CAL_QTR_END_DT" DATE , "CAL_QTR_FLAG" VARCHAR(30) , "CAL_QTR_BEGIN_FLAG" CHAR(1) , "CAL_QTR_END_FLAG" CHAR(1) , "CAL_MONTH_WEEK_NUM" SMALLINT , "CAL_YEAR_WEEK_NUM" SMALLINT , "CAL_DIM_WEEK_NUM" INTEGER , "CAL_WEEK_STR" VARCHAR(30) , "CAL_WEEK_START_DT" DATE , "CAL_WEEK_END_DT" DATE , "CAL_WEEK_FLAG" VARCHAR(30) , "CAL_YEAR_STR" VARCHAR(30) , "CAL_YEAR_START_DT" DATE , "CAL_YEAR_END_DT" DATE , "CAL_YEAR_FLAG" VARCHAR(30) , "CAL_DAY_OF_WEEK" VARCHAR(30) , "FSC_MONTH_DAY_NUM" DECIMAL(2,0) , "FSC_YEAR_DAY_NUM" DECIMAL(3,0) , "FSC_DAY_STR" VARCHAR(30) , "FSC_MONTH_NUM" SMALLINT , "FSC_DIM_MONTH_NUM" INTEGER , "FSC_MONTH_STR" VARCHAR(30) , "FSC_MONTH_START_DT" DATE , "FSC_MONTH_END_DT" DATE , "FSC_MONTH_FLAG" VARCHAR(30) , "FSC_MONTH_END_FLAG" CHAR(1) , "FSC_QTR_NUM" SMALLINT , "FSC_QTR_STR" VARCHAR(30) , "FSC_QTR_START_DT" DATE , "FSC_QTR_END_DT" DATE , "FSC_QTR_FLAG" VARCHAR(30) , "FSC_QTR_BEGIN_FLAG" CHAR(1) , "FSC_QTR_END_FLAG" CHAR(1) , "FSC_MONTH_WEEK_NUM" SMALLINT , "FSC_YEAR_WEEK_NUM" SMALLINT , "FSC_WEEK_STR" VARCHAR(30) , "FSC_WEEK_START_DT" DATE , "FSC_WEEK_END_DT" DATE , "FSC_WEEK_FLAG" VARCHAR(30) , "FSC_YEAR_STR" VARCHAR(30) , "FSC_YEAR_START_DT" DATE , "FSC_YEAR_END_DT" DATE , "FSC_YEAR_FLAG" VARCHAR(30) , "PAST_FLAG" CHAR(1) , "HOLIDAY_FLAG" CHAR(1) , "WEEKDAY_FLAG" CHAR(1) , "CAL_WORK_DAY_NUM" INTEGER , "FSC_WORK_DAY_NUM" INTEGER , "ALL_WORK_DAY_NUM" INTEGER , "SEASON_TEXT" VARCHAR(254) , "EVENT_1_TEXT" VARCHAR(254) , "EVENT_2_TEXT" VARCHAR(254) , "EVENT_3_TEXT" VARCHAR(254) , "EVENT_4_TEXT" VARCHAR(254) , "DATE_ATTR1_CODE" VARCHAR(30) , "DATE_ATTR1_NAME" VARCHAR(254) , "DATE_ATTR2_CODE" VARCHAR(30) , "DATE_ATTR2_NAME" VARCHAR(254) , "DATE_ATTR3_CODE" VARCHAR(30) , "DATE_ATTR3_NAME" VARCHAR(254) , "DATE_ATTR4_NAME" VARCHAR(254) , "DATE_ATTR5_NAME" VARCHAR(254) , "DATE_ATTR6_NAME" VARCHAR(254) , "CDC" INTEGER , "INVOICE_NUMBER" INTEGER , "INVOICE_START_DT" DATE , "INVOICE_END_DT" DATE
Is there something wrong with this one ?
Or maybe into data and not structure ?
Thanks for help,
Alexandre.
Solved! Go to Solution.
I have more precision : I have this error only with column in DATE format.
Maybe an error with language connection ?
Hi @Anonymous,
Maybe you can take a look at below link which about link to IBM datasoure.
Cannot connect to AS400 via IBM DB2 database
In addition, if you use additional t-sql query to remove date type columns and try again, does this issue appears again?
Regards,
Xiaoxin Sheng
Hi @Anonymous,
>>When I add a CAST VARCHAR on DATE columns, I have no more problem.
If it only appears when you use date type, I think the issue may related to it. Which date format you used to stored these time value? Can you share some sample?
Notice: Current power bi not support to analysis specify timestamp format. If this is a case, I'd like to suggest you convert them to normal date format before import.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |