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.
devguru001DevAsked:
Who is Participating?
 
devguru001Connect With a Mentor DevAuthor Commented:
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
 
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
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
 
devguru001DevAuthor Commented:
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
 
Brian BEE Topic Advisor, Independant Technology ProfessionalCommented:
No problem. Thanks for sharing your solution.
0
 
devguru001DevAuthor Commented:
Found a workaround to the problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.