Forum Discussion

samdthompson's avatar
samdthompson
Memorable Member
9 years ago
Solved

Operation cancelled by user

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
 
Help appreciated, thanks,
  • samdthompson's avatar
    samdthompson
    9 years ago

    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

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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's avatar
      samdthompson
      Memorable Member

      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