Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM Report Authoring E...
Microsoft Dynamics CRM (Archived)

CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

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

Hello,

I have tried installing CRM Report Authoring Extension 2016  on my laptop to create Fetch-XML reports based on records in CRM but, the tool cannot be installed.

First it tells me Live ID Sign-in assistant is not installed, then after it automatically installs it, it gives another error,

Business Intelligence Development Studio is not installed for Microsoft SQL Server Reporting Services


I'm sure I've installed VS2017 with SSDT because I have created sql-based report with it but cannot see Microsoft Dynamics CRM Fetch as datasource!

I would appreciate any clue.

Thanks a lot

*This post is locked for comments

  • Keith Mescha Profile Picture
    Keith Mescha on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    You can use Fetch queries with On Prem as well.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Dear All,

    I have installed "Microsoft Dynamics 365 Report Authoring Extension" instead of "Microsoft Dynamics 2016 Report Authoring Extension" and it's fixed now. Now I wonder If I can use it to create FetchXML from on-premise CRM server

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Hi Again,

    I have installed VS 2013, SQL Data tools for VS2013. but still when I try to install CRM Report Authoring Extension for it, I get an error at the end saying:

    Business Intelligence Development Studio is not installed for Microsoft SQL Server Reporting Services

    I have downloaded SSDTBI_x86_ENU and SSDT_14.0.61704.140_EN but didn't solve my issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Dear Mohamed and Gopalan,

    Yes I have installed BI studio but I guess Gopalan is right. maybe I cannot use report authoring extension with VS2017. I'll try VS2015 and let you know.

    Thanks for fast comments and replies!

    Narbeh

  • Gee Bee Profile Picture
    Gee Bee 11,397 on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Hi

    VS 2017 is not mentioned in the list of VS versions.

    Refer the Report Authoring Extension requirements section in the download page for the same.

    https://technet.microsoft.com/en-us/library/hh699754.aspx#report_ext_gen_req

  • Suggested answer
    M I Mostafa Profile Picture
    M I Mostafa 4,257 on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    So the error you are getting says: "Business Intelligence Development Studio is not installed"?

    If that's the case, have you tried to install Business Intelligence Development Studio and then try to install report authoring extension?

    msdn.microsoft.com/.../jj856966(v=sql.120).aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Hi Mohamed,

    I have downloaded and installed SSDT for VS2012 and 2015 . My VS is 2017 and I have installed SSDT from the setup as well.

    The issue is I still cannot install Report authoring extension as it shows the same error and I cannot select Microsoft Dynamics CRM Fetch as a type for a datasource.

  • Suggested answer
    M I Mostafa Profile Picture
    M I Mostafa 4,257 on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Hi Narbeh,

    thanks for clarifying. The second response is applicable to on-premise.

    Have a look at the following tech article at about versions supported:

    technet.microsoft.com/.../dn531151.aspx

    Basically, you need to use SQL Server Data Tools.

    Hope this helps! Please click on "yes" to verify the answer if you found this response helpful.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Dear Mohamed,

    Sorry If I didn't mention. We are using on-premise version of CRM 2016

  • Suggested answer
    M I Mostafa Profile Picture
    M I Mostafa 4,257 on at
    RE: CRM Report Authoring Extension 2016 cannot be installed on Windows 8.1

    Just to add, here are the versions supported for Dynamics 365 CRM custom report authoring.

    Microsoft SQL Server Reporting Services is required for reporting features in Microsoft Dynamics 365.

    You can use the following Microsoft SQL Server editions for Microsoft Dynamics 365 reporting; you’ll need to install them on a Windows Server 2012 (x64 RTM or R2) 64-bit-based computer, running and available for Microsoft Dynamics 365:

    *Microsoft SQL Server 2016, Enterprise with Cumulative Update 2 (CU2)

    *Microsoft SQL Server 2016, Standard with Cumulative Update 2 (CU2)

    *Microsoft SQL Server 2016, Developer, with Cumulative Update 2 (CU2) (for non-production use only)

    SQL Server 2014 Enterprise, 64-bit

    SQL Server 2014 Business Intelligence, 64-bit

    SQL Server 2014 Standard, 64-bit

    SQL Server 2014 Developer, 64-bit (for non-production use only)

    Microsoft SQL Server 2012, Enterprise, 64-bit SP1

    Microsoft SQL Server 2012, Business Intelligence, 64-bit SP1

    Microsoft SQL Server 2012, Standard, 64-bit SP1

    Microsoft SQL Server 2012, Developer, 64-bit SP1 (for non-production use only)

    Full details here:

    technet.microsoft.com/.../hh699754.aspx

    Hope this helps! Please click on "yes" to verify the answer if you found this response helpful.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans