Gateway error "Cancellation occurred when sending or receiving a request"

[Mlamb]

Gateway error

  I then tried to manually refresh the dataset via the Gateway and received the error “Cancellation occurred when sending or receiving a request.” I Googled this error and found that other people have the same problem, but I could not find a solution from Microsoft. Since there is not enough detail in the error message, the most common recommendation I saw was to open a ticket with Microsoft Power BI Support.

Error details are below.

Last refresh failed: Fri Feb 09 2018 09:18:08 GMT-0800 (PST)
Cancellation occurred when sending or receiving a request.Hide details (https://app.powerbi.com/)

Cluster URI:

WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net

Activity ID:

bc484392-d16b-5d74-3ed5-d367afe4c1ba

Request ID:

f5f37335-8196-c960-e75d-89ff65d77bf6

Time:

2018-02-09 17:18:08Z

PowerBI Log files are located here

https://www.dropbox.com/s/kvkbekcfzvpk0m3/ODGLogs%202018-02-09T09_44_18.zip?dl=0

Thanks in advance for any assistance

[savio_ferrao]

How do we find what the exact issue is as I am facing similar issue but there is no info as to what the exact cause can be.

And I am trying to add all the tables from my database they are about 400+ tables and I have no way to find which exact table crashed in refresh

[hassanmoosajee]

Hi,

I am encountered the same issue.

What are some other reasons this could be happening?

Any suggestions?

[Mlamb · Accepted solution]

 Fixed.  Problem was a duplication in a Group By Field.