-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Power Query Cookbook
By :

Data analysts and business intelligence users generally don't have editing permissions on data sources. You can't change data types directly on the database. Asking for custom changes may require time and it can be complex. In this sense, Power Query becomes a powerful tool because it helps you define and customize data types. In this recipe, we will see different options on how to change data types of specific columns or of entire tables.
For this recipe, you need to have Power BI Desktop running on your machine. You need to download the following files in a local folder:
FactResellerSales
CSV fileFactInternetSales
CSV fileIn this example, we will refer to the C:\Data
folder.
Once you open your Power BI Desktop application, you are ready to perform the following steps:
Figure 4.1 – Text/CSV connector...