Forum Discussion

MarlonK's avatar
MarlonK
Icon for Helper I rankHelper I
5 years ago
Solved

PowerQuery removes nullable binary field when saving data flow, making full folder load impossible

I have created a dataflow on PBI service that connects to a SharePoint folder, with the intention of having it grab all the CSV files in the folder. Everything looks good initially, I can see the CSV...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    MarlonK 

    I have experienced the same issue and expanded the Binary column in the Dataflow itself then connected from Desktop.

    ________________________

    If my answer was helpful, please click Accept it as the solution to help other members find it useful

    Click on the Thumbs-Up icon if you like this reply 🙂


    Website YouTube  LinkedIn

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

MarlonK 

I have experienced the same issue and expanded the Binary column in the Dataflow itself then connected from Desktop.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

MarlonK's avatar
MarlonK
Icon for Helper I rankHelper I
5 years ago

Yeah, that seems to be the only choice. 

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi MarlonK ,

     

    This is casued by this warning:

     

    Based on my test, after you choose "save & close", it automatically deletes these columns with complex types.

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.