Analyze in Excel Error: MaxPacketLimitReached

I have the exact same issue but it comes about when I am running a DAX query from Report Builder. 

The query references tables from a Power BI model in the Power BI Service, ie cloud.  The model is hybrid in the sense that all tables are in import mode but one, which is is in DirectQuery mode via a gateway to an on-prem SQL Server DB (2017).

So, the DAX that Report Builder is trying to run references both the DirectQuery table and imported tables.  The DirectQuery mode cannot be imported because there is simply too much data to import the table as a whole. 

The error message is exactly the same:

{"error:
"{"code":"DM_GWPipeline_Client_MaxPacketLimitReached",
"pbi.error":"code":"DM_GWPipeline_Client_MaxPacketLimitReached",
"parameters":{},
"details":[],
"exceptionCulprit":1}}}

The initial working result set size the DAX query needs to work on is < 900K.  I am trying to get DAX to further filter it down to a couple dozen rows:  It works fine in DAX Studio, but when running from Report Builder it craps out. I suppose Report Builder uses a DAX engine inside its own process and tries to get all the initial data it needs to work on instead of telling the DAX engine in the cloud, ie in the Power BI Service, to perform the computation and once finished send the smaller result set.

Of note is that the result set DAX starts with from the DirectQuery of the DB never exceeds the 1M row limit. Therefore why does Report Builder emit this error????

None of it makes any sense. But hey, I guess I should start getting used to the fact that not much makes sense when it comes to DAX, especially its inability to refer to table variable names that are supposed to be in scope but won't be recognized as existing because only a base table ref will do.  What a wonderful DSL (Domain Specific Language)!