ETL

[AndyDDUK]

Hello everyone

We use a competiting product to upload data on a weekly basis and update client dashboards.

The ETL process cleans the data and appends it to a database

I've seen alot of detail on how quick and easy it is to create a Microsoft Power BI dashboard and I totally get it...

If you can share how the ETL/append data to a database using Power BI works be great to hear from you.

Many thanks

Andy

[Kahi2018]

Thanks by Advance! 🙂 waiting for your replies , all welcome 🙂

[ImkeF]

Another way is to use an R-script: https://business-insights.net/2017/08/17/export-power-bi-tables-to-sql-server-database-using-r/

[Kahi2018]

Hi everyone,

Can we use TALEND as Etl tool with Power BI solution ?

Your answer will be helpful as soon as possible, I couldn't find any info/resource about it :// 

Thanks A Lot 

[v-qiuyu-msft]

Hi @AndyDDUK,

You can take a look at this sample, which use Power Query get data in Power BI desktop and export to SQL database use PowerBIETL: Use Power BI Desktop as an ETL Tool.

Best Regards,
Qiuyun Yu

[Kahi2018]

Ps: I'm all new in the BI , actually am comparing diffrent BI solutions in order to choose then set one for my business (as a computer scientist)