Let’s review how to use Microsoft Power Query(MPQ) as your data source. And how you can ingest and transform that data. This post will be an overview of the MPQ as we’ll go further in depth with the section “Transform, cleanse, and load data by using Power Query”.
First, you go to data and add your data source, you then select Microsoft Power Query.
After…
Continue Reading Malin Martnes’s Article on their blog
MB-260: Ingest and transform data using Power Query connectors
The Microsoft Power Query connector gives you a lot of different ways to connect with your data. In this post we’ll go through the overview of the MPQ connector.
Blog Syndicated with Malin Martnes’s Permission