Forum Discussion
Data view is blank
I have imported an Excel table into Power BI. I know that the data came across correctly because I can see it in visualizations. However, when I go to the data view or attempt to add relationships,...
The only workaround I found and worked for me is to use the "table" function in Excel.
1. Mark all your needed data in the Excel file
2. Go to tab "Insert" > "Table"
3. Confirm the selected data and save the Excel file
4. Import your Excel file into Power BI again
After these four steps, the relationships should be ok and there should be no more null values.