Need Help with SQL Server Express, Folder of CSVs and Power BI

Hello, I have a folder of CSVs that is updated daily. I want to get those into an SQL server and connect to Power BI. The reason I am going this route is Power BI currently just imports the CSVs...

analytics

Business Intelligence

Data Warehouse

Javier_Villegas
Mar 21, 2024
Hi shaebert

I have a similar situation and I am using DBATools , specifically the module Import-DbaCsv which allow you to imports multiple files in one shot into a SQL Table

https://docs.dbatools.io/Import-DbaCsv.html

It is a PowerShell tool and definitively super easy to use.

Since you use SQL Express Edition you don't have a SQL Server Agent to schedule the task but you can use Windows Task Scheduler

Regards

Javier

Javier_Villegas

MVP

Mar 21, 2024

Hi shaebert

I have a similar situation and I am using DBATools , specifically the module Import-DbaCsv which allow you to imports multiple files in one shot into a SQL Table

https://docs.dbatools.io/Import-DbaCsv.html

It is a PowerShell tool and definitively super easy to use.

Since you use SQL Express Edition you don't have a SQL Server Agent to schedule the task but you can use Windows Task Scheduler

Regards

Javier