DM_GWPipeline_Client_MaxPacketLimitReached

[Nicolas76]

Hi,

I am a premium user.

I have created a "master report" with all my measures but no "content", and I have published it to "My Workspace".

Then, I am used to creating various "dedicated reports" using this "master report" as data base.

It allows me to have all my measures at the same place in the "master report". When I need to create a new measure for a "dedicated report", and I think that it could be useful later in other reports, I create the measure in "master report", and publish it: the measure then becomes available in the "dedicated report" I was working on, and all the other reports based on "master report".

This process was working perfectly until recently.

The issue is the following.

I am working on a chart showing the result of a "heavy" query.

When I have it in the "master report" (to test), it is OK: the chart appears.

But when I copy this visual in a "dedicated report" (once more, this report uses the "master report" as data source through "My Workspace"), I encounter a "DM_GWPipeline_Client_MaxPacketLimitReached" error. Full error message below.

Any help would be appreciated!

Thanks in advance,

Nicolas

--

Product Version:
2.80.5803.1061 (20.04) (x64)

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

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 fr-FR)

CLR Version:
4.7 or later [Release Number = 528049]

Peak Virtual Memory:
38.1 GB

Private Memory:
383 MB

Peak Working Set:
531 MB

IE Version:
11.1158.17763.0

User ID:
XXXXX

Workbook Package Info:
1* - fr-FR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
False

AS Live Connection:
True

Performance Trace Logs:
C:\Users\XXXXX\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_hierarchicalSlicerCreation

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_inlineExplore
PBI_realTimeRefresh
PBI_v3ModelsPreview
PBI_decompositionTree
PBI_relativeTimeSlicer

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

Formulas:

section Section1;

[jscherbring · Accepted solution]

I found the root cause of this errorin my situation. There was a fact table with more than a million records set to Dual storage mode, when this table was set back to direct query we no longer received the error.

I believe it has to do with how the service handles queries when importing a table and being able to break the results down into sets less than 1M records whereas the dual storage mode is intended more for dimensional (i.e. smaller) tables and this causes the error as it tries to refresh the dual mode tables.

[Nicolas76]

In my case, the problem has been solved today by replacing a SUMX/FILTER query by a CALCULATE query.

[jscherbring]

I'm running into the same error message in a similar situation (a composite dataset containing direct query tables and import tables), but there are no visuals in my case. The dataset is empty with no visuals or reports. When I try to reresh the dataset via the service it fails with the same error message, but on the desktop it works fine.

@Nicolas76  - did you find a resolution to the issue? 

[v-lionel-msft]

Hi @Nicolas76 ,

Your data seems to reach a certain query limitation.

What is your connection mode? Direct Query?

Maybe you can refer to the case .

Limitations of DirectQuery 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nicolas76]

Hi @v-lionel-msft ,

Thanks for you answer. 🙂

Yes, I am using DirectQuery mode (and I cannot switch to Import).

However, I am not sure that I am facing a limitation of DirectQuery, since the visual is OK in report A directly using the data base as source.

The problem appears when I copy/paste the visual in report B, which uses report A as data source through publish.

Could the problem be linked to publish or gateway?

Nicolas

[v-lionel-msft]

Hi @Nicolas76 ,

It may be because your copy and paste operation of the visual led to the query exceeding the limit of 10 millions rows.
You try to copy and paste other small data visual, if successful, it proves that the query limit is indeed reached, otherwise, please create support ticket .

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.