Data view is blank

[BMA]

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!

[bvdm1980]

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.

[Mandy0833]

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.

[dosansil]

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. 

[Star_Dust]

I have the same issue too, other functions work well, however, I can't create relationships between query

Anyone can help on this please?

thanks

[v-haibl-msft]

@BMA

I notice you have already found this post, have you tried the solutions in that thread?

If possible, could you please provide the excel file to us for troubleshooting?

Best Regards,

Herbert

[Anonymous]

has anyone find a solution above?

Thanks

Mike

[Anonymous]

Has anyone find a solution to the problem above?

[a_mixed_life]

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.