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.
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.
