Forum Discussion

dean_flynn's avatar
dean_flynn
Regular Visitor
1 year ago
Solved

Excel Data Type from Power BI Semantic Model Not Resolving New Values

Hi everyone, I'm encountering an issue with Excel's integration with Power BI Data Types and wondering if anyone else has seen this recently. This a new problem - up to a week ago, it was working f...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi dean_flynn,
    Thank you for reaching out to the Microsoft fabric community forum. 

    Since you have already opened a support ticket with Microsoft, this is the appropriate step for a deeper investigation, particularly if it involves environment specific behaviour or requires backend review. While you are working with the support team, please continue to share any updates here. If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

    Thank you for using the Microsoft Community Forum.

burakkaragoz's avatar
burakkaragoz
Super User
1 year ago

Hi dean_flynn ,

 

This is a great summary of the issue and troubleshooting steps—thanks for sharing all the details. This kind of sync problem between Excel and Power BI semantic models has come up for other users as well, especially after recent Office or Power BI service updates.

A few additional things you can try:

  • In Excel, go to File > Account and check for updates. Install any pending Office updates, then restart Excel. Sometimes, updates fix integration bugs with Power BI Data Types.
  • Sign out and back in to your Microsoft account in Excel (File > Account > Sign out, then sign in again). This can refresh your credentials and connections to Power BI data sources.
  • In Excel, go to Insert > Data Types > Manage Data Types and remove/re-add the “Watches” data type. Sometimes, Excel holds onto a stale cache or connection.
  • Try creating a completely new Excel workbook and connect it to the semantic model. If the new workbook works but old ones don’t, it’s likely a caching issue in Excel.
  • Double-check that your Power BI tenant settings (especially for featured tables and Excel integration) haven’t recently changed due to admin policy updates.
  • If you have access, check the Power BI service’s support page or admin center for any known issues or incidents related to Excel integration.

If none of these steps resolve it, you might be running into a backend change or a bug related to recent updates in either Excel or Power BI Service. In that case, I’d recommend opening a support ticket with Microsoft and referencing all the steps you’ve already tried.

Let me know if any of these steps help or if you spot any new behavior when testing with a new workbook or after updating Office.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI