Establish a dynamic connection between a dataset in Dataiku and Excel

[ptavares]

I would like to be able to create a dynamic connection between a dataset in Dataiku and Excel, so that any changes in Dataiku would be automatically refreshed in an Excel file.

There is a plugin available that connects Dataiku and Power BI dynamically. Please see the link below:

Plugin: Microsoft Power BI | Dataiku

My question is if there is a similar way of connecting dynamically Dataiku and Excel.

Thanks in advance,

Paulo

---

Operating system used: Windows

[Turribeach · Accepted solution]

Not as a plugin but you don't need much to do this. Add a Python recipe to your last flow output dataset and write the output as a Excel file in a Dataiku Managed Folder. For an even more seamless integration you could mount your network share in Dataiku, create a new File System Connection and place the Dataiku folder there so that users could see the Excel file in their network share without you have to send it to them.

[Turribeach · Accepted solution]

Not as a plugin but you don't need much to do this. Add a Python recipe to your last flow output dataset and write the output as a Excel file in a Dataiku Managed Folder. For an even more seamless integration you could mount your network share in Dataiku, create a new File System Connection and place the Dataiku folder there so that users could see the Excel file in their network share without you have to send it to them.

[me2 · Accepted solution]

There are two additional options available if you use Microsoft 365 and2 excel file options as well.

1) Dataiku is able to connect to Sharepoint and Dataiku can export to a Sharepoint folder.

2) Dataiku is able to connect to OneDrive and Dataiku can export to a OneDrive folder. 

There are differences on the Excel side on how one is able to interface/link to that file and worth exploring before deciding.

Dataiku is able to write as an Excel file as @Turribeach mentioned.  Also if there is multi-sheet option but that saves the file in a compressed folder.

Happy Dataiku'n!