Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

How to import Microsoft Lists data into Power BI. The integration feature is powerful and effective at creating a quick prototype or giving you, the designer, a quick start.

Whether your data resides in Excel files, SQL Server databases, or cloud-based services, Power BI simplifies the process of bringing it all together. Follow these steps to connect to your data: ...