Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Sillsree15
Frequent Visitor

PowerBI Gateway issue

HI Team,

Schedule refreshing is failling and below is the error , I have two gateways when I am pointing old gateway refresh is success , but  when pointing to new gateway it is getting failling.

 

Error - Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError",
"pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":
[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},
{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC:
SUCCESS_WITH_INFO [01000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General warning;1 general warning:
currency/unit conversion finished with warnings\n could not convert value ''
to longdate because value '' is not a valid date\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult",
"detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail"
:{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":
"dsn=GBP_Bluebook"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":
"error \"Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf)
at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf)
at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.
Mashup.Engine1.Runtime.BufferedListValue.BufferedValueReference.get_Value()#(cr)#(lf) at Microsoft.Mashup.Engine1.
Runtime.TableTypeValue.FromValue(ListValue columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.
Engine1.Library.Table.TableModule.Table.FromRowsFunctionValue.TypedInvoke(ListValue rows,
Value columns)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0,
Value arg1)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.
<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.
DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.
TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record\""}},{"code":
"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Order Data.

 

Could some please help me in this issue.

Thanks in Advance..

Sreeni

1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @Sillsree15 ,

 

I am keying in on this part of the error:

 

"general warning:
currency/unit conversion finished with warnings\n could not convert value ''
to longdate because value '' is not a valid date\n"}},"

This indicates to me that somehwere in a date field column you have a non-valid date field.  You might not see it right away so I suggest the you find the date column(s) and then do a filter, do a sort by , and maybe add a "trim" step but you have to manually hunt this down in your date fields.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

1 REPLY 1
collinq
Super User
Super User

Hi @Sillsree15 ,

 

I am keying in on this part of the error:

 

"general warning:
currency/unit conversion finished with warnings\n could not convert value ''
to longdate because value '' is not a valid date\n"}},"

This indicates to me that somehwere in a date field column you have a non-valid date field.  You might not see it right away so I suggest the you find the date column(s) and then do a filter, do a sort by , and maybe add a "trim" step but you have to manually hunt this down in your date fields.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!