Disabling query load

Queries' loads can be heavy and sometimes refreshing some tables can impact negatively on performance. This is why it is important to know what data is concretely needed for end users. It is common that you will need some queries just for transformations in Power Query, but you won't need them in the final model. In this recipe, we will see how you can use some queries for enriching data needed for reporting and how you can disable the loading of this supporting table in order to reduce the impact on performance and refreshing.

Getting ready

For this recipe, you need to download the following files:

• The FactInternetSales CSV file
• The DimTerritory CSV file

In this example, we will refer to the C:\Data folder.

How to do it…

Once you open your Power BI Desktop application, you are ready to perform the following steps:

1. Click on Get data and select the Text/CSV connector.
   

   Figure 6.59 – Text/CSV connector

...