Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rjmajid
Frequent Visitor

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/
1 REPLY 1
collinq
Super User
Super User

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors