Operation cancelled by user

[samdthompson]

Hi, I have a report for which one tile gets the error:

'operation cancelled by user'

It works perfectly on desktop

It comes from one SQL source

If I change the slicers it works for other data combinations

The gateway is fine

All the other tiles work perfectly. There are no errors in the data

The technical details are:

Activity IDa0a02554-a183-4f4d-88ae-5fac7c2321b3

Request ID2d7f00f5-7f4f-f949-6440-5d1e44a95368

Correlation ID92d09c0f-f8a4-dddf-99d5-785757d12bdc

TimeWed Jul 12 2017 08:13:39 GMT+1200 (New Zealand Standard Time)

Version13.0.1828.219

Cluster URIhttps://wabi-australia-southeast-redirect.analysis.windows.net

Help appreciated, thanks,

[v-yulgu-msft]

Hi @samdthompson,

Please tell us the reproduce steps in your scenario.

What visual prompts such an error? What is the data type in source table? Did you create any measure referring to wrong data type that might cause such error? Also, check the detailed values stored in source table.

Please provide more detailed information so that I can test for you.

Regards,
Yuliana Gu

[samdthompson · Accepted solution]

The visual is a table.

The visual works in dektop so it not an incorrect data type.

The visual also works in PBI service if I change the slicer selection.

I have also tried making the visual again in PBI service with the individual components and it works fine, there are no visual specific filters.

The data is not huge. Its 3 fact tables, 1 of approx 785k rows, on or 250k rows and one of 120k rows. The Dimension tables are no bigger than 18k

[v-yulgu-msft]

Hi @samdthompson,

Have you tried to republish this report to service?

Regards,
Yuliana Gu

[samdthompson]

Yes I have.

[v-yulgu-msft]

Hi @samdthompson,

What operation you made on service would make it prompt such an error?

Could you provide some sample data and tell us how you created the report so that I can test in my environment?

Regards,
Yuliana Gu