Office Apps Freezing

Fix Blank Relationship View in Excel and Power BI Desktop

Algirdas JasaitisAlgirdas Jasaitis Nov 22, 2026 868 views

Question details

Restore the relationship diagram in Excel's data model and Power BI Desktop.

Fix Blank Relationship View in Excel and Power BI Desktop
Product
Microsoft Excel Data Model and Power BI Desktop
Device & OS
Windows; version not provided
Scenario
The user wants to view existing data model relationships in Excel and Power BI Desktop.
Observed behavior
The relationship view appears black, blank, or frozen in both applications even though relationships exist.
Before you start

Record when the relationship view last worked and check the installed Excel, Power BI Desktop, and Windows versions. In Excel, open Power Pivot > Manage > Diagram View; in Power BI Desktop, select Model view to confirm where the issue occurs.

Solution 1Recommended

Check Recent Windows and Office Updates

Use this approach if the problem began after an update or affects both applications.

1
Review Windows updates

Open Settings > Windows Update > Update history and note updates installed around the time the issue began.

2
Check application versions

In Excel, open File > Account to review the Office version and update options. In Power BI Desktop, open File > About to record its version.

3
Install available updates

Use Windows Update and Excel's File > Account > Update Options > Update Now to install available updates, then restart Windows and test both relationship views.

4
Consider a Windows update rollback

If the issue started immediately after a Windows update, open Settings > Windows Update > Update history > Uninstall updates and check whether that update can be removed. Consult your IT administrator first if the device is managed.

Check Recent Windows and Office Updates
Rollback is not a guaranteed fix: One reported case improved after a Windows update was removed, but uninstalling security updates can expose the device to risk. Follow your organization's update policy.
Free Microsoft Office alternative

Work with Excel Files in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with compatible spreadsheets. Open Excel files to continue ordinary spreadsheet tasks, though WPS does not fix Microsoft relationship views or replace Power BI's data modeling features.

Open and edit compatible Microsoft Excel XLSX filesUse familiar spreadsheet tools for everyday analysisMove common Office documents into a lightweight workspaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why is the relationship view blank in both Excel and Power BI?

A shared Windows, graphics, or display issue may be involved, but the cause is not certain. Check Settings > Windows Update > Update history and review recent graphics driver or display changes.

Can a Windows update cause the relationship view to stop working?

A Windows update was associated with the issue in one report, and removing it restored the view for that user. Check Windows Update > Update history and consult your IT administrator before uninstalling an update.

Where can I find the relationship diagram in Excel?

Open the workbook, select Power Pivot > Manage, and then choose Diagram View in the Power Pivot window. The Power Pivot tab must be available to access this view.

What should I include in a Power BI Community post?

Include your Windows, Excel, and Power BI Desktop versions, recent update history, when the issue began, and the troubleshooting steps you have already tried.