ETL

AndyDDUK · ‎02-24-2017

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 · ‎04-17-2018

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

ImkeF · ‎04-18-2018

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/

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Kahi2018 · ‎04-17-2018

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 · ‎02-26-2017

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kahi2018 · ‎04-17-2018

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)

ETL

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024