Forum Discussion

Nicolas76's avatar
Nicolas76
Frequent Visitor
6 years ago
Solved

DM_GWPipeline_Client_MaxPacketLimitReached

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 report...
Need Help
  • jscherbring's avatar
    jscherbring
    6 years ago

    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's avatar
Nicolas76
Frequent Visitor
6 years ago

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's avatar
v-lionel-msft
Community Support
6 years ago

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.