Duplicate Measures in Excel – Tabular Model 1600

Question

Dear Microsoft Support -

We are seeing duplicate measures and duplicate measure folders in Excel when connecting to our Tabular Cube.

Environment:

1. Compatibility Level: 1600
2. Excel: Microsoft 365 (Version 2511 Build 16.0.19426.20118) 64-bit

Business users previously accessed the model in Excel without any issues. The duplicate measures began appearing this year, but we are not sure exactly when the issue started. Users are very confused by the duplicate measures that are now showing up.

Power BI connects to the same Tabular model and works fine without any duplicate measures.

Please see the attached screenshots showing before and after.

Is this a known issue? Do you have a hotfix or recommended solution?

Thank you.

Answer 1

Hi @Cathy Yan,

Thank you very much for taking the time to share additional detailed information.

To help other users on the forum more easily search for and reference useful information, I would like to summarize the issue and the resolution as follows:

Issue Duplicate measures and duplicate measure folders appear in Excel when connecting to a Tabular Cube.

Environment

• Compatibility Level: 1600
• Excel: Microsoft 365 (Version 2511, Build 16.0.19426.20118) 64-bit

Resolution Updating Windows may help resolve this issue.

Once again, thank you very much for sharing your valuable information.

Kind regards,

 

Answer 2

Hi @Cathy Yan,

Thank you for contacting us.

I would like to provide you with the following information:

You mentioned that the issue only occurs with Excel, while the connection works normally when using Power BI. Please try the methods below to check whether the issue can be resolved:

Method 1: Remove and reconfigure the connection in Excel Please try deleting the current connection and setting it up again in Excel.

Method 2: Clear Excel cache In some cases, Excel may store outdated information in its cache, which can cause data to display incorrectly or be duplicated.

• Step 1: Select File > Options
• Step 2: Go to Save, scroll down to Cache Settings, and select Delete cache files

If the issue persists after trying both methods above, I recommend contacting Microsoft Technical Support so they can perform a more in-depth investigation of this case.

Note The steps below require tenant administrator permissions. If you do not have admin rights, please contact your organization’s IT department for assistance.

• Step 1: Go to admin.microsoft.com
• Step 2: Select Help & Support
• Step 3: Enter the title: Need support checking Excel
• Step 4: Select Contact Support
• Step 5: Choose the appropriate contact method

After the ticket is submitted and assigned to an agent, a support representative will proactively reach out to you to assist with further investigation of the issue.

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.   

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.

I look forward to continuing the conversation.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 3

The issue of duplicate measures and measure folders in Excel when connecting to a Tabular Cube can occur due to various reasons, including changes in the model or Excel settings. While the context does not specifically mention a known issue related to duplicate measures in the compatibility level 1600, it is important to ensure that the measures are correctly defined in the Tabular model and that there are no discrepancies in the Excel connection settings.

Here are some steps you can take to troubleshoot this issue:

1. Check for Updates: Ensure that both Excel and the Tabular model are updated to the latest versions, as updates can sometimes resolve unexpected behavior.
2. Review Measure Definitions: Verify that the measures in the Tabular model do not have duplicates in their definitions. Sometimes, measures can be unintentionally duplicated in the model itself.
3. Recreate the Connection: Try removing the existing connection to the Tabular model in Excel and then reconnecting to see if that resolves the duplication issue.
4. Consult Documentation: Look for any known issues or guidance in the official Microsoft documentation related to Excel and Tabular models.

If the problem persists, consider reaching out to Microsoft Support for further assistance, as they may have more specific insights or solutions for your environment.

---

References:

• Unable to access on-premises Analysis Services
• Measures in tabular models