Fix Blank Relationship View in Excel and Power BI Desktop
Question details
Restore the relationship diagram in Excel's data model 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.
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.
Check Recent Windows and Office Updates
Use this approach if the problem began after an update or affects both applications.
Open Settings > Windows Update > Update history and note updates installed around the time the issue began.
In Excel, open File > Account to review the Office version and update options. In Power BI Desktop, open File > About to record its version.
Use Windows Update and Excel's File > Account > Update Options > Update Now to install available updates, then restart Windows and test both relationship views.
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.

Review Graphics, Scaling, and Compatibility Settings
Check display-related settings that may affect how the model diagram renders.
Ask the Power BI Community for Dedicated Troubleshooting
Use this option if the relationship view remains blank after the update and display checks.
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.

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.




