SQL Server 2019 MDS excel addin returning subset of data in the entity

Rakesh Kosuru (Capgemini America Inc) 0 Reputation points Microsoft Vendor

SQL Server 2019 MDS excel addin returning only subset of data for the entity. Web UI is returning all the rows. Any pointers on how this could be resolved will be of great help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,300 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Debarchan Sarkar - MSFT 931 Reputation points Microsoft Employee

    [5:24 PM] PurviewBot In SQL Server 2019, Master Data Services (MDS) Excel Add-In is a powerful tool that allows you to work with MDS data directly from Excel. However, there can be instances where the add-in does not return all the rows for an entity even though the web UI does. Here are some steps that might help resolve your issue: Check the filter settings in Excel: In certain scenarios, inadvertent filter settings in Excel might cause only a subset of data to be visible. Ensure that no filter conditions have been applied. Refresh the Data: There might be rare occasions when the excel add-in doesn't refresh properly and doesn't fetch all the data. Try refreshing the data inside your excel sheet using the refresh option provided by the add-in. Verify Version Compatibility: Confirm that both your version of SQL Server 2019 and Excel are compatible with the MDS Excel Add-In. An incompatible version may cause performance issues including not fetching all data. Check for Errors in Add-In: Check whether the MDS Add-In has logged any errors during the operation. The logs can provide useful insights into what might be causing the issue. Contact Support: If none of the above solutions work, it would be advisable to reach out to Microsoft support for further assistance.

    Remember, these suggestions are based on general troubleshooting steps and without more specific information about the issue, it's difficult to provide a more precise solution. It would be helpful if you could provide any error messages you received or elaborate more on when and how this problem occurs. As a next step, you could try to: Check your Excel and MDS Excel Add-In versions. Clear any filters in the Excel sheet and try again. Look for any logged errors by the MDS Add-In.

    Please let me know if you need further assistance.

    0 comments No comments