Solved

Data Quality not found in excel ribbon

Posted on 2016-10-27
5
17 Views
Last Modified: 2016-11-08
Hi

Im implementing a solution that requires Data Quality Services and Master Data Services integration using MS excel.  My problem is that the Data Quality ribbon is not visible.  I have done the following:

  1. DQS and MDS installed on the same server
  2. Enabled DQS integration via MDS config manager
  3. Installed MDS client for excel on local

I notice that on the ribbon customisation, Data Quality is listed

Problem.png
My environment details
  • SQL Server 2014
  • Windows server 2012
  • Excel 2013

Any assistance would be highly appreciated.
0
Comment
Question by:devguru001
  • 3
  • 2
5 Comments
 
LVL 23

Expert Comment

by:Brian B
ID: 41862927
It appears you don't have any data selected. You have to follow certain steps before the options become available. Those are outlined here:

https://msdn.microsoft.com/en-us/library/hh548683.aspx
0
 

Author Comment

by:devguru001
ID: 41862939
Hi Brian

Thanks for your speedy response

According to your article, one should have MDS-managed worksheet.  Unfortunately, im still not seeing the ribbon.  (see attachment below)
Loaded-data.png
0
 

Accepted Solution

by:
devguru001 earned 0 total points
ID: 41873265
Hi

I have found a solution (I cant however explain why it works).  I readded the commands that are not in the ribbon into a new group and it works.  I experienced the same issue with powerview.

Thanks for your contribution
0
 
LVL 23

Expert Comment

by:Brian B
ID: 41873310
No problem. Thanks for sharing your solution.
0
 

Author Closing Comment

by:devguru001
ID: 41878471
Found a workaround to the problem
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question