Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Status Code 500

I am encountering a status code 500 message when I try to modify an existing dataflow. This happens for several dataflows. I can no longer save changes made to a dataflow. This is happening in dev, t...
Dataflow
  • Anonymous's avatar
    Anonymous
    5 years ago

    No solution has been provided, but the issue went away on its own. Not really a solution. Maybe the man behind the curtain is resolving it without letting anyone know.

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
4 years ago

This is still happening.My scenario is when I edit a query that has been set for incrimental refresh.  I edit it to pass the range params to a function that folds them into the sql for an odbc query.

 

let
    //Source = ODBC_BLP800CFBL(SalesOrdersSQL,pFrom, pTo)
    Source = ODBC_BLP800CFBL(SalesOrdersSQL,RangeStart, RangeEnd),
    #"Changed column type" = Table.TransformColumnTypes(Source, {{"DATE", type datetime}}),
    #"SalesOrders-44415445-autogenerated_for_incremental_refresh" = Table.SelectRows(#"Changed column type", each DateTime.From([DATE]) >= RangeStart and DateTime.From([DATE]) < RangeEnd)
in
    #"SalesOrders-44415445-autogenerated_for_incremental_refresh"