Blob Column

[Syndicate_Admin]

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 bolb column is actually an excel table that may or may not differ from the previous day's excel in its contents, but its structure (columns) is the same.

I would like to be able to extract and combine them all together with the initial date column (as a column for each row of each binary) to obtain a table that is updated every day with all the new records generated, following a process similar to that followed by the connection against a folder of, e.g., CSVs.

Is it possible to automate this connection?

Thank you very much!

[Syndicate_Admin]

Good morning!

I have implemented the query as if it were a folder processing and I have achieved the goal!

Thank you very much for the help!

[Anonymous · Accepted solution]

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.