Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Why does my data not shown when loaded onto PBI?

Hi all,   Need your help to troubleshoot for me this particular issue I'm facing...   I loaded an Excel workbook onto my existing PBI by clicking "Excel Workbook" and then  "Load".   The data w...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi amitchandak,

     

    Thanks for the tip. I realised there were extra empty rows when it was copied and pasted in Excel. Deleted that and it solved the problem.

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , I doubt empty rows also got loaded. in power query remove empty rows and then try

Power Query Remove Empty/Duplicate rows: https://youtu.be/Hk8QtBfcm6k

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak,

     

    Thanks for the tip. I realised there were extra empty rows when it was copied and pasted in Excel. Deleted that and it solved the problem.