Could not load the data for this visual

[rjmajid]

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/

[collinq]

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.