Forum Discussion

rjmajid's avatar
rjmajid
Frequent Visitor
3 years ago

Could not load the data for this visual

Live data connect through attached error, it does not show visual

 

Couldn't load the data for this visual

The SELECT permission was denied on the object 'VWActive_Campaign_Data', database 'Reporting', schema 'dbo'.. The exception was raised by the IDbCommand interface.

Please try again later or contact support. If you contact support, please provide these details.Hide details
  • Activity ID52986bae-3c1a-42ef-add6-9dde44c57c95
  • Request ID8f06c722-aedb-4753-ae80-2c8eda4b4dd2
  • Correlation IDb750be14-684d-9cf6-5b29-7bf9f0b0f9ec
  • TimeFri Jun 23 2023 15:33:59 GMT+0100 (British Summer Time)
  • Service version13.0.20913.58
  • Client version2306.2.14324-train
  •  

    Couldn't load the data for this visualThe SELECT permission was denied on the object 'VWActive_Campaign_Data', database 'Reporting', schema 'dbo'.. The exception was raised by the IDbCommand interface.

    Please try again later or contact support. If you contact support, please provide these details.Hide details
    • Activity ID52986bae-3c1a-42ef-add6-9dde44c57c95
    • Request ID8f06c722-aedb-4753-ae80-2c8eda4b4dd2
    • Correlation IDb750be14-684d-9cf6-5b29-7bf9f0b0f9ec
    • TimeFri Jun 23 2023 15:33:59 GMT+0100 (British Summer Time)
    • Service version13.0.20913.58
    • Client version2306.2.14324-train
    • Cluster URIhttps://wabi-uk-south-redirect.analysis.windows.net/
Need Help

1 Reply

  • collinq's avatar
    collinq
    Super User
    3 years ago

    Hi rjmajid ,

     

    That error means that the userid being used to get the data from VWActive_Campaign_Data does not have the appropriate permissions.  Whether that is your userid or the gateway you will need to get the permissions to at least be able to read the data on that table.