Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |