Day 20: Importing and Exporting Data

In today's video we'll learn simple methods of importing and exporting data. We'll be looking at not only the Maker methods, but also the end-user or Model Driven app consumer methods for exporting to a CSV. We'll also do a demo of how you can import a table from SharePoint into Dataverse very easily - but this method can be used for any of the data sources available in Power Query.

Note: Tomorrow we'll explore this topic even further as we will discuss the recommended service for migrations and synchronizations which is Dataflow.

Recommended reading and watching:

Data Import and Export:

Using File Templates:

BONUS VIDEO 1: Power CAT Live video on Alternate Keys with Yasin Alladin Mukadam:

BONUS VIDEO 2: Data Migration Utility by Brian Knight of Pragmatic Works:

Previous Videos:
15. Day 15: Easy as Pie Power BI Integrations:

Additional assets for this series will be kept here in the Power Apps community:

Enjoy,
Audrie