While I am refreshing a Data Flow on the Service, by local PBI Desktop program struggles to load the preview of a local excel file in the power query window. As in, takes 10+mins to load the preview.
This makes no sense - one uses the Gateway (on this computer), the other uses the mashup engine - or am I missing something.
You may take a look at Understanding and optimizing dataflow refresh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.