Data is not displayed in Data Tab

Question

Hi everyone!For some reasons the data from the one of my files is not visible in the Data tab of PowerBi Desktop. When I try to filter it there is a list of values. Also the correct numbers appear in the report. The only problem is the visibility in the Data Tab.&nbsp;&nbsp;Data source: simple Excel file with 1 sheet of data (7.000 rows, 15 columns).Way of importing to PowerBI (usual): NewSource-&gt;Excel (local file on my PC)-&gt;Select sheet-&gt; OK (previosuly always used Edit, but there is no more this button, does it dissaper with the new update of PowerBI?)Other Excel files from the same local folder works perfectly fine in PowerBI (including Data Tab).&nbsp;Any ideas how to solve it?Thanks!

v-xicai · Answer

Hi Sergii24&nbsp;,&nbsp;Maybe you have made some data filters in Data view, you can enter into the Query Editor to check.&nbsp;Based on my test in the latest version 2.70.5494.761 Of Power BI Desktop, it have the all buttons as usual. You can upgrade to the latest version 2.70.5494.761 Of Power BI Desktop, and try it again.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards,Amy&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;

v-xicai · Answer

Hi&nbsp; Sergii24&nbsp;,&nbsp;Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.&nbsp;Best regardsAmy

mariusz · Answer

Hi&nbsp;Sergii24&nbsp;It looks like there is an issue with your excel file, try to clean it from the bottom up (there might be some filled cell at the bottom of the file).&nbsp;Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me.&nbsp;