Excel data file from SQL

[amiskow]

I have a query from sql database (direct)

One of the columns is an Excel file (see photo)

Is it possible to load the data of these files?

[PhilipTreacy · Accepted solution]

Hi @amiskow 

Yes, click on the double down arrow in the column header 

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[amiskow]

Hi, @PhilipTreacy 

I need to use this column in Desktop, but can't see it (see image)

[mahoneypat]

As @PhilipTreacy  replied, you first need to combine the binaries in the column.  You can do this by either hitting the double arrows, or by adding a custom column and use the Excel.Workbook() function on the column of binaries.  This would expose all the sheets, tables, etc. in each workbook and you could filter/expand from there. Once all the data are expanded, you can then load the table and see the columns on the report page.

Regards,

Pat