Importing database created in Job to PowerBI

Anonymous — Sat, 16 Nov 2024 04:02:14 GMT

I am planning to create a PowerBI dashboard based on a table created in sqlite database. The database was created upon runtime of a job in Talend Open Studio. The dataflow of the job in Talend is briefly explained below :

import data --> do some transformation --> tDBOutput

What I am hoping to get is when I run the job, the flow is as follows

import data --> do some transformation --> tDBOutput --> PowerBI imports table created from tDBOutput and creates dashboard.

Is this available in Talend ? I have researched somewhere that PowerBI can connect with talend using an ESB component like tREST to set up connectivity between Talend and PowerBI. I am not very clear on this yet and I would appreciate listed steps on how to acheive that.

Thanks

Re: Importing database created in Job to PowerBI

Anonymous — Mon, 25 Nov 2019 03:50:20 GMT

Hi
There is no a special component for integrating with PowerBI, however, if PowerBI provides API, you can use tRest component to call the API to push the data to PowerBI.

Regards
Shong

topic Importing database created in Job to PowerBI in Talend Studio

Importing database created in Job to PowerBI

Re: Importing database created in Job to PowerBI