Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

invalid Datasource reference error for SSRS Reports

Posted on by

Hi all,

I am trying to upload rdl for ssrs report into my crm 2011 but i am getting below error :

"invalid datasource reference error". I am using shared dataset and SP both are deployed on server. Can someone please tell me if i am missing something. 

Thank you

*This post is locked for comments

  • Rakhi Sharma Profile Picture
    Rakhi Sharma on at
    RE: invalid Datasource reference error for SSRS Reports

    Hi,

    Yes the user has all the privilege.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: invalid Datasource reference error for SSRS Reports

    Hello,

    Please check that the user which is uploading this reports has privilege on the data source and SP.

  • Rakhi Sharma Profile Picture
    Rakhi Sharma on at
    RE: invalid Datasource reference error for SSRS Reports

    Hi,

    This is happening for all the reports which i am trying to deploy on CRM 2011. I am not sure what is that i am missing.

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: invalid Datasource reference error for SSRS Reports

    Take a look at the following link regarding using a Shared Data Source:

    stackoverflow.com/.../adding-ssrs-report-through-crm2016-prefiltering-doesnt-work

    Hope this helps.

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: invalid Datasource reference error for SSRS Reports

    Hi Rakhi,

    Seems the .rdl file has some issue . Does it happening for all report of specific report ?

    Could you please check below article. I am not sure I am just trying to help you.

    http://olegkapustin.com/2013/12/ssrs-fix-rsinvaliddatasourcereference/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans