Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Data Quality not found in excel ribbon

Posted on 2016-10-27
5
Medium Priority
?
22 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 25

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 25

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

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

927 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