Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Excel Data is not shown in the Data Field

Hi there, 

I am currently working on a  report based on a import query from a database. 


I do needed to add a excel to the report, weirdly though I can import it and can work with the data in "Edit Queries" and in the report itself.
But in the Data Tab nothing is showing up, therefore I can´t establish any relationships as it shows no data. 


I tried refreshing it, deleting the table again and uploading it again, copying the code into a new blank querry, but nothing helped. 

 

Anyone has experienced this bug before?

 

Thanks for the help,
Johannes

  • Anonymous's avatar
    Anonymous
    7 years ago

    It seemed that the excel file seemed to have an error. 
    Once I copied the data into a new .xlsx file, the data was being shown.  

2 Replies

  • Anonymous this is really weird, never seen this before. can you try totally new powerbi report and check it. There is no logical reason but may be pbix metadata is corrupt. Just an idea.

    • Anonymous's avatar
      Anonymous
      Not applicable

      It seemed that the excel file seemed to have an error. 
      Once I copied the data into a new .xlsx file, the data was being shown.