Forum Discussion

jskipper's avatar
jskipper
Frequent Visitor
4 years ago

Dataflow fails during save

Hi

 

I copied a number of query from Power BI Desktop to a dataflow, where I could save and refresh the dataflow.

 

Now I am trying to a make a small change by adding a custom column to the dataflow. In the query editor it show no error message but it fails without any useful explaination when saving. As soon as I removed the newly added column then I can save the flow again.

 

Custom column + format change of that column: 

 #"Added custom" = Table.AddColumn(#"Added LE Qty calc", "Package size SPP", each if [Package type] = "Letter" then 1 else if [Package type] = "Parcel" then 2 else 3),
#"Changed Type7" = Table.TransformColumnTypes(#"Added custom", {{"LE Qty calc", Int64.Type}, {"Package size SPP", Int64.Type}})
in
#"Changed Type7"

 

The dataflow is running on a premium capacity.

Less than 30.000 row with about 70 columns.

 

MasterData is basically appended based on the 3 master data queries, where some of them merge with data in the helper tables. I have allowed merging in the dataflow.

 

Activity ID: baacbd8b-d4e3-4221-b34a-41410181a77a
Request ID: d0d35458-6208-11d4-6390-6dd700e93ba8
Correlation ID: acecc290-6bba-4f5e-922a-3bbfb3dda70b
Status code: 500
Time: Thu Sep 16 2021 10:19:21 GMT+0200 (Central European Summer Time)
Service version: 13.0.16736.54
Client version: 2108.5.07549-train
Cluster URI: https://wabi-north-europe-f-primary-redirect.analysis.windows.net/

 

 

Dataflow

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi jskipper ,

     

    According to your description, the main error should be a problem with the added custom column.


    Once you add a custom column, make sure it has an appropriate data type. If you see the Any The Any data type icon icon to the left of the column header, change the data type to what you want. For more information, see Add or change data types.

     

    In addition, there are restrictions on the data types supported by the data stream.

     

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.