Authentication to data sources
Power Query provides different connector types to a wide range of data sources. These will be widely explained in the following chapter, but in this recipe, we will concentrate on how authentication works for data sources.
Each connector provides different kinds of authentication. There are six main types of authentication:
- Anonymous
- Windows
- Basic
- Organizational account
- Microsoft account
- Database
Depending on the type of connector and the Power Query version used, different combinations of these options will be available for the user.
Once you connect to your data source and you perform Power Query transformations, you will be able to change the type of authentication and the data source without losing the work you have done.
Getting ready
In this recipe, in order to test different types of connections, you need to have the following data sources to which you can connect:
- An Azure SQL Database with...
