Power Query - Load to Data Model

Copper Contributor

Hello All,

 

I would like to get your support in order to know how to select the queries to load to the data model from Power Query.

 

On Excel 2016/365 on the Power Query Editor I have a couple of support queries and then a "final" query that got input from the support ones (as one example append two queries into a new one). Then I make the load to the data model and it will load all the queries available on the Power Query (and I just want to load the "Final" one and not the support ones). There are any setting that allow to select with query load to the data model?

 

For example on the Power Query on Power BI Application I know that there are the option of the "Enable Load" that allows to select which queries to load to the data model. So, In the Power Query for Excel 2016/365 there are a similar feature?

 

Thank you in advance,

1 Reply

Hi @Crak1000

If you have any doubts related to power BI please read the doc's, 

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh