cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HarRuc Frequent Visitor
Frequent Visitor

importing data from csv to sql data warehouse

I have 100s of heavy CSV files and wanted to upload it on Sql Data WareHouse, and then connect it with PowerBI. Whats the best way to do so?

 

I have referred to this page which talks about using bpc commands, but then it has requirements of UTF-16 and requires tables to be created beforehand, which seems a LOT of effort before we can import 12GB worth of csv file in sql data warehouse. Isnt there a way to drag and drop the data into sql data warehouse or something as easy?

 

Any pointers appreciated.

2 REPLIES 2
Super User
Super User

Re: importing data from csv to sql data warehouse

We have had great success using Azure Data Factory for this kind of thing. Here are all of the various options:

 

https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-overview-load/

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-qiuyu-msft
Moderator

Re: importing data from csv to sql data warehouse

Hi @HarRuc,

 

Based on my research, you can use SSIS package to import CSV files to SQL database, then import data from SQL Server to SQL Data Warehouse. For more information, please take a look at below links:

 

Importing data from CSV To SQL using SSIS ScriptTask

Load data from SQL Server into Azure SQL Data Warehouse (SSIS)

 

As the issue is more related to Azure SQL Data Warehouse, I would suggest you create a thread in Azure SQL Data Warehouse forum to get dedicated support.

 

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.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 319 members 3,067 guests
Please welcome our newest community members: