Avatar of devguru001
devguru001
Flag for South Africa asked on

Data Quality not found in excel ribbon

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.
Microsoft ExcelWindows Server 2012

Avatar of undefined
Last Comment
devguru001

8/22/2022 - Mon
Brian B

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
devguru001

ASKER
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
ASKER CERTIFIED SOLUTION
devguru001

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Brian B

No problem. Thanks for sharing your solution.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
devguru001

ASKER
Found a workaround to the problem