Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Blob Column

Hello! I have a query where there is a date columa and another blob. Each day is updated with a new date and a new blob record that translates into an excel file. Each "binary" element of the b...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Syndicate_Admin ,

     

     

    Please try like the following method:

    After you connect to your  data,turn to the  Power Query Editor, select Content (the first column label) and select Home > Combine Files. Or you can just select the Combine Files icon next to Content.

     

    In addition, you can easily apply additional transformation or extraction steps by modifying the automatically created exemplar query, without having to worry about modifying or creating additional function query steps. Any changes to the exemplar query are automatically generated in the linked function query.

     

    For more information,you can refer to:

    Combine files (binaries) in Power BI Desktop 

     

    Hope it helps,


    Community Support Team _ Caitlyn

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