Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / The selected data exte...
Microsoft Dynamics CRM (Archived)

The selected data extension MSCRMFETCH is not installed or cannot be loaded

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi, i need help.

I'm tring to connect a report to Dynamics 365, but when I select the datasource type doesn´t appear "Microsoft Dynamics Fetch", instead i see MSCRMFETCH.

When I tried to use that, so appeared this message:

"Unable to connect to data source 'DataSource1'.The selected data extension MSCRMFETCH is not installed or cannot be loaded.  Verify that the selected data extension is installed on the client for local reports and on the report server for published reports.".

I'm using SQL Server data tools for visual studio 2012 and already I installed the CRM Report Authoring Extension.

5305.error.PNG

*This post is locked for comments

  • CU10062144-0 Profile Picture
    CU10062144-0 3 on at
    The selected data extension MSCRMFETCH is not installed or cannot be loaded
    One of my colleagues suggested installing the "Dynamics 365 Report Authoring Extension". Once you have it, check your "Data Source" (properties), General, Embedded connections, Type (list). It should contain either MSCRMFETCH or "Microsoft Dynamics 365 Fetch" in the list.
    If you need to download it from https://www.microsoft.com/en-us/download/details.aspx?id=56973 or search Microsoft's site for "Dynamics 365 Report Authoring Extension". 
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    Hello Santiago ,

    Did you try to change the name :Datasource1 with 'MSCRMFETCH'

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    Hello ,

    This is happening due to multiple time install of reporting extension or may be the version mismatch.

    You can refer below link. Hope this helps

    support.microsoft.com/.../you-receive-the-following-error-when-you-install-microsoft-dynamics-cr

    support.microsoft.com/.../fatal-error-during-installation-of-microsoft-dynamics-crm-2013-report

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    Download and Install Reports Authorising Extension file. 

    This will help..

    Thank You

  • Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    Hi Roopa,

    Did you managed to fix the issue. If so can you pls lemme know the issue route cause Since we are facing the same error while previewing the report from VS.

  • Roopa Profile Picture
    Roopa 295 on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

  • Roopa Profile Picture
    Roopa 295 on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    I opened Visual studio from Microsoft SQL Server 2012 > SQL SERVER Data Tools

    Now I can see the data source in the report wizard as "Microsoft Dynamics 365 Fetch"

    I tried providing connection string as the CRM Application URL "https://xxx.crm6.dynamics.com;;UniqueName"

    I give right credentials.

    but its throwing below error always

    ---------------------------

    Sign-In Failure

    ---------------------------

    Can’t use the cached credentials to sign in to Microsoft Dynamics 365. You may have insufficient privileges to sign in.

    ---------------------------

    OK  

    ---------------------------

    07218.Capture.PNG

    Please advice.

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    Try reinstalling the authoring tools.. if it does not help, get Visual Studio 2015 + Data Tools, then reinstall the authoring tools again.. but use Visual Studio 2015 to build reports after that

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    I didn't could find the solution, i had to use another pc, and worked.

  • Roopa Profile Picture
    Roopa 295 on at
    RE: The selected data extension MSCRMFETCH is not installed or cannot be loaded

    HI,

    Did you find the solution?

    Even I have the similar issue.

    Please suggest me, how did you fix this?

    Appreciate quick response.

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

News and Announcements

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,316 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans