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, I only see nulls. I have added and readded the table and that does not fix the issue. I'm new to PowerBI, so it's probably something simple I just don't know about. Thanks!
8 Replies
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.
Is the excel file that you're pulling that from are "Values" only? Possibly pulling formulas?
That's the only thing I can think of.
I am having this same issue. The data still present in the Power BI, because the visualizations work properly, but when clicking on the data view I can't see. Whatever, when I clicked on the edit queries the data stay there.
Hi, just had the same problem. Issue was having empty data rows in my original excel table that i imported. So you can prob sort in power bi data view, remove empty rows, or remove them from your table. THat should do the trick.
