cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
avalos Frequent Visitor
Frequent Visitor

"This table is empty" importing from Excel

Hello

 

I am having a problem with an imported table from Excel. The table has about 48,000 rows, and I cannot update the report in Power BI, since it keeps telling me I have 483 errors. 

 

When I display the errors, it tells me that the table is empty. The step right before it brings the error is and the table being indexed. Besides that, there is no other hint on what the problem might be. 

 

Any idea on where can look in depth for more information about this error?

 

t5.03.jpg

t5.04.jpgt5.05.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: "This table is empty" importing from Excel

Hi @avalos ,

By default, PowerBI Desktop will not trace these errors. In this scenario, we need to enable the trace first, then reproduce this problem, after than analysis the log.

Please refer to the following steps enabling the trace: Go to File->Option and settings->Options->Diagnostics, enable tracing. When error occurs, click Open crash dump/trace folder, we wil get the log file.

Snipaste_2019-04-23_10-42-58.png

Best Regards,

Teige

View solution in original post

2 REPLIES 2
avalos Frequent Visitor
Frequent Visitor

Re: "This table is empty" importing from Excel

When updating the report I got this error (part 1):

 

Failed to save changes to server. Returned Error: 'The following system error has occurred:

CommitTransaction

{"changes":[{"updateDataSourceConnectionString":{"dataSource":"f48b526f-2342-4c9d-9dcc-8fa11ec32bcf","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=\"UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTnO0JuAuAgAAigUAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAI2UTWsTQRjH74F8h2F7SWANWSheSg9rUyEKBtLgJQQZk4kGdnfC7qxUwoKJxjZN4wuaiiiKUEHwpChSTPHDrJOXU7+CM5nNbpPsJs4lM/M8839+88+zY6EyqWED7IlfZSsei8es+9BEFbAhqSoAN9VsIZfPXlEksA00ROIxwIbbOncfD9zWGdvcgxqyqtgso1Qe1bFJrERSFmkbUjqdS+M0H9fu1TObu+oNruMfbxRvQR1th6WVnGIGEljypeiLHu303OYxPe0M3/1wm323dew2P9LDN4CLFuBdjSMYTHEHa7ZuWIlQALnRkMbff9HnJ8Num56/ujP6+WR09lqSgeTNHBnMp4wftXk4WEwzaP/p+OsB4+Ixf3Ex+COOSo4TGEG/9ScnXR8aiJTJwcvJp15Av7tfh0Ylj8rYrIg7JNZcnFWek+JcUMe2QS7fQgRTs8AMi3aOJm9P5wQDH3X84JKPK/nlNXWWj//93aftz2xxMTgcfXk2PHrvNplznZVWLOOy20cqLToRlbjsyoLNH7o+VMGEBu91XRAVHtZRmDnRTI31HDLIGuTqZoqLz3XQijZQoj6A5bv8H0K0rQGSahMs2sT7gyyFUYiY/1LwQXy46ybWb0PNRmvaWmEIxQyqQlsjQpu/E0xm4U0qzVj4MAVLRAsT2dv2NnJVbjDfbhA2AYQHZTCdm9Ou8xZazSJOMinq1IygXmhLcE4r4aGwkmifpHY0BA0mMDscYtzWP1BLAQItABQAAgAIALmQlk7SJK4hqwAAAPoAAAASAAAAAAAAAAAAAAAAAAAAAABDb25maWcvUGFja2FnZS54bWxQSwECLQAUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAAAAAAAAAAAAAAAAD3AAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQAAgAIALmQlk5ztCbgLgIAAIoFAAATAAAAAAAAAAAAAAAAAOgBAABGb3JtdWxhcy9TZWN0aW9uMS5tUEsFBgAAAAADAAMAwgAAAGMEAAAAAA==\";location=\"AA KAITORI-1\""}},{"updateDataSourceConnectionString":{"dataSource":"3d8946f2-2d94-481c-bfc0-b368c76798c1","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTlQMoVyWAgAAwAcAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAKVVz28SQRS+k/A/TLYX2qyENcZL0wP9YeilTSjxICFmhUFJll2yO5gaQlKgCJRiNUqbaFOj1WjjRQlqiBD/mHX4ceq/4MzOslDcBRrnsm/ee/PN976ZN6vBKEooMthhX2HZ7XK7tEeiCmNggfP7AQj4t1b9mzcEDqwACSK3C5Ch5zt6oa3nW8S5I0pQiytqFHqDMKWoSPMs8ixtgfP5tn2Kj47Vh6lAYMN/j+JYyzPhLTEJV+zSItnwuojEiAWFn9dwpabnDvGHSvdNU8/V9fyhnnuLyyeAgobEBxKlIBPENUVKJ2XNY0uAz2S4fuMnPjruVou48/J+7/t+r/VqieMBx0wuy4OrOf29ohG3ZuMpuP60/6VEw8wiTC/bv/uNC3ze4LLZkRr4W31wXLWYAxLHteag9GLwrjYqYWM3JcqxIIwqaowV4plRPd15HIpSE5NKWkaM5njQOwwMaU0CnlUtJiFVlOnRJhmN0JMUpJpOLYOqa7cfDzZldPuWl4JM0+TPrzoufiSTy3a59/lZ9+BUzxE5K0tTBfq3CKKJM9SkQI6Zc6glXFeuKbQyc1CZV8he4wSXL/5TRYH2hD3QpIb2aXMIePO6AjoRyswi4SjdlOYSnN4Wm0IoA71wqhdKev4cd973Dn4Yr8aEz2zKsypuHxlxZjL3YO9179NXwsiIWDNzTatprTFM5/6efBPmu+dTu2aOY3a+LiO9/WmkBGFSeQzNe6fRFmIx6w9DB7KUv6MqybuilIYzXkKBEAivw7iYlhDDpv8XAnP1VxYZUqFDZVTGTpnOh6eMeNNtOrbj9PJQdwYRAyAa5IFhq0YvmRMpoaHs4iLbJyGP9rO96pSm5jGpkC3hLvKuSVCUCcBwsY1uy38BUEsBAi0AFAACAAgAuZCWTtIkriGrAAAA+gAAABIAAAAAAAAAAAAAAAAAAAAAAENvbmZpZy9QYWNrYWdlLnhtbFBLAQItABQAAgAIALmQlk4PyumrpAAAAOkAAAATAAAAAAAAAAAAAAAAAPcAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAACAAgAuZCWTlQMoVyWAgAAwAcAABMAAAAAAAAAAAAAAAAA6AEAAEZvcm11bGFzL1NlY3Rpb24xLm1QSwUGAAAAAAMAAwDCAAAAywQAAAAA;location=\"AA HANBAI-1\""}},{"updateDataSourceConnectionString":{"dataSource":"6ecf52c3-17b4-4347-b667-0f4a439cf07d","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=\"UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTuF6YVzdAgAAfAUAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAH1U308TQRB+J+F/2Jwv1+RSKRoTxZpAEW00SijoQ9uQpV2gYXtr7rZSbJpA1woIBIz8MhoUARWJQFBjoEX+mOWO8sS/4F7veoiH7MvdzXw7883MN6ejBE0RFUTsZ6Cpvq6+Tu+HGkoCXvjG2Qpn33mhxNkGCAKMaH0dEIcX9jkr88KuMN7OJhD2PybaQA8hA3JbCiN/iKgUqVSXpdCNWJeOND32DEHcrVMNUtQ31NAYu0NIH0aAs3HO1nlhlbP5GGej1bAHxtgLc2km1k4GkQZawvZLS9j1c/bGzu/PYj0r+RSgZjBWANUyyKfUOJ6h3x3pR4gKvi73XDRMUToo/QOUlHspNRmUqngpno+2QgrjTlBzcdT8UOYjc7wwyUfec7bIGeNsWEQ057ZF9E7YI+pv10iaUHQXwaSoXT6XigKiDqwZ40gCYqjpQauAeK0CY3XcfPvDTWYsTbgJOjWo6r1ES4cIzqTVzqEnSJcvJqfkcpKx9ds4eGcurEmiV+IOSIpx5BWQk8zZLWNvoWamKEur5qOfz492Zz1mc6Jo7L+uDBc9nq6O+x6bUWQi5WFp0ZPVmN4WzIQ5rNJrV/1WGVV7pfTy6MumJxBnXzmbtabHxi6b89uVT9MeTHO7Mbkn9ONxHC9/NjY/GjNTHs9JeUxM6KQ8Xtn5ZUzPH4++Ol6e8pL6C7ZurOz8D3ZYmjOKa7ZXXLHB4pYXaQnZEv7ZtuddATMxSKGajargT+daWZ50dRBBWGxuBxnUZa9aFIBgoh9E3anHwa0guGR1X25sCFxXwFUFBHwAqskzoJse0JUGX41Vc4aSDpQmT1HS1p4eEGxsn/t/sA51SbYJmT+COIPkC0oS69CKemEGUzvsA5hGIoJnO93tsI5mE3Ez2cQcXrJYMdvsGB72Wq23zDm73ZbTab2GEkRLOh84pdO8z2fnSamn+c5dPoupLjtUREoxRH8II6iKALXL53St6Q9QSwECLQAUAAIACAC5kJZO0iSuIasAAAD6AAAAEgAAAAAAAAAAAAAAAAAAAAAAQ29uZmlnL1BhY2thZ2UueG1sUEsBAi0AFAACAAgAuZCWTg/K6aukAAAA6QAAABMAAAAAAAAAAAAAAAAA9wAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAIACAC5kJZO4XphXN0CAAB8BQAAEwAAAAAAAAAAAAAAAADoAQAARm9ybXVsYXMvU2VjdGlvbjEubVBLBQYAAAAAAwADAMIAAAASBQAAAAA=\";location=キャンセル"}},{"updateDataSourceConnectionString":{"dataSource":"5a7d5711-a18a-40b8-8963-a59bf1b47ad5","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=\"UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTr2Wks0UAgAAfwQAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAJVTW2sTQRR+D+Q/DNuXDYwhAfGlVlhbFS8YSIIvIQ9jMrGB3Z2wO/HCsmASCgmmVG2TIC1KsUJBsK0UpBLbHzPMNn3KX3Cme1HbpZjzMnPOfPOdb86cY+MKrRMTFPw1O59MJBP2MrJwFcwpmgbAvZz2qHAtq4AFoGOaTABhrP2LdcasfSSCBaRju0asCk7ncYNY1FZT0IfNKZlMLkMy0m4/azxEd7QHkie67pQeIwMvxMHKbmkJUVSOqPjbVd5bZa0+3+l5m4esNWDtPmt94t0RkKRF9FSXEkzBuEj0pmHaaqwA6DgK3zueHGzzo0Nvq6tAIH1+suWNviguBI4iomfD9dPNb97uB7627w32Jcj3p+OuH5qOe4rrhm+9qOrjm0hT0UKmrJDhyyq+amAp7coHSZEx+SC4b9Ib19OS41zpdPzu7PWBQE6+/+BrwwuSL4HfzwJenwW8MQt4MAt4+H/g6CdYRxTyM+t8Ze0T2WZhXSfb/ehLClgXDZ8nL2z18sdBgFFlGaglb2OP/xyVwc1bokNWdk93jpVUmEVrUpLHBnmOq0G3ZQW7fxbNiTQaJb1rEeMJ0ptYvUIiBKUlXENNnfq0ckAEwz+jWA5FSLN8EX9NgPTDCaAwCAeBXE0WS4YdKjaAykMIzvcWrhCrGjh63aZuKuXnqZt/8sX2tFRpq4EUkRK/pOlFHSNTEISXYyo2/xtQSwECLQAUAAIACAC5kJZO0iSuIasAAAD6AAAAEgAAAAAAAAAAAAAAAAAAAAAAQ29uZmlnL1BhY2thZ2UueG1sUEsBAi0AFAACAAgAuZCWTg/K6aukAAAA6QAAABMAAAAAAAAAAAAAAAAA9wAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAIACAC5kJZOvZaSzRQCAAB/BAAAEwAAAAAAAAAAAAAAAADoAQAARm9ybXVsYXMvU2VjdGlvbjEubVBLBQYAAAAAAwADAMIAAABJBAAAAAA=\";location=\"AA GOALS-1\""}},{"updateDataSourceConnectionString":{"dataSource":"9ba4cefc-5138-4a36-a5a7-44e0d582b9e7","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=\"UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTv0wufzvAQAAAwQAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAI1TTUsbQRi+B/IfhvWShDXsnsXD1o+LqBCDh4Yg02Sigd2dsDsrlrDQpLVRVBTaGGgpBdGDCIJfaETxx2wnSU/+hc5k9iPBtPa97Ps1z/s87+zYqEDK2ARL4qtOxGPxmL0GLVQEY5KmAaAq89rCuCqBSaAjEo8BZl790fv44NXbLLkEdWSXsFVA6QyqYIvYiaQs2sYkRVlUsMLtzWplbnlGe8txwuPV3AI00OSotrybm4YE5kMoerBHt/e82i493u58v/ZqTa++69V+0q0W4KBZ+E7nFEyGOIV1xzDtxEgCcrUq9S5v6f5hZ2eTPn5Z6d586ra/piQZSMKVXBkM9/Q+bPbrYSRaaPuK/mh0L1t067R7dE/Pv3VaJwIoiAaxaPNz76zBy8Jjkp4fnlTl111Dct1oa/Si+ftwJ1QIBsekIq0zGxVoFjOogK2iUJx4ZU188hAW5wYN7JjkpaBUOqgk/+sS1L/fwr8F8QsZOfgF3WhJmkNwBhl4HfnSbZVNF7XwN+VGQlKzFjaWoe6gV7aksrm5aVSCjk4ENv9JGczQc8gHTLhZgsmAfh4H+onsp/3EYin7voJ4ukqYAwgvyqDvW/3b9AO9bBM3mRRzymY0T8BlLWjyl2dELO2ET4WNRBskPaUjaDKA4PCItU38AVBLAQItABQAAgAIALmQlk7SJK4hqwAAAPoAAAASAAAAAAAAAAAAAAAAAAAAAABDb25maWcvUGFja2FnZS54bWxQSwECLQAUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAAAAAAAAAAAAAAAAD3AAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQAAgAIALmQlk79MLn87wEAAAMEAAATAAAAAAAAAAAAAAAAAOgBAABGb3JtdWxhcy9TZWN0aW9uMS5tUEsFBgAAAAADAAMAwgAAACQEAAAAAA==\";location=\"AA 10MAN-1\""}},{"updateDataSourceConnectionString":{"dataSource":"0f5ef6a4-e5df-4e75-8397-62ff34f57686","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=\"UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTpSkZi+SAgAA6goAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAKWWy27aQBSG90i8w8jZgOQizKWbKAuHUKmbUhGUVEIspjAoSL4ge6hSWSwANSqF9CKVRG2kdtF21UUvahe9Pc3ItHmLzmDwDceyw2yw5/jM/5/vR7J11MQdVQH71q+wnUwkE/oR1FALbHGiCED53t0bAgd2gIRwMgHoIsM/ZPSbDH/QzX0oIb2tak2UqaKuqmE9leatx7a4bLaSVbNs7R5V9MOyeMDOsduN+h0oo52gxxr9+h7EsGEfZX6ZXZ5NyGBGhlMyeAsuL16Yz56ajz6wE2vwvoQy5eMuVFpV1FS1VkmVerKSCrTAA87p5oHBQVntKZjrs2u7klntOuOYz0/N8SkZTM334/nFN9uM+fgcODaqSKFTWQb0VJhz3gjQ87jr2+p+yTcTW7CmQYVFIFuatYddtNANc+uRppq3FXyzkGGtfffAPuvzl5/Mn+d/v0//ff0Vyn3dLR3L0+3n7i7GRC9EZ++1YATL+q2GhSBskoKwZiFyEqXStVIQ6Gx2qz+CVSEm/lx0/I60sS7nthaGPLcJ8pxHOjLuw/LutXjn6FBOrx+4XYlJPB+duEvcCBD02AuDnt8Eet4rHpm6KM7Hk/ns8/zsVUzueTqYu9tP3lWLyb4Qnb3HgBEo6rMZlkBhkwQKfgORMyCj12T0hIw+ktEJGb6LmUOBDug/wZ+Frx4zj2L0PNaMGFeKB9gOy6a4STbFICNX5CP2sFpFsvoALZnr7AVk1ezPM7aw7eiWpsoHUOqhgHiKPKjvoTbsSdg6jn2P0U7Xd19jJc2WZkm7iLP7FXHML7eXG5U2M8+2DUwvAGZFHiyutcX/ZnkjdXTcT6ctnY7i6AUyZR711NIKlUTHOFOSEFToAavmAE7b/wFQSwECLQAUAAIACAC5kJZO0iSuIasAAAD6AAAAEgAAAAAAAAAAAAAAAAAAAAAAQ29uZmlnL1BhY2thZ2UueG1sUEsBAi0AFAACAAgAuZCWTg/K6aukAAAA6QAAABMAAAAAAAAAAAAAAAAA9wAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAIACAC5kJZOlKRmL5ICAADqCgAAEwAAAAAAAAAAAAAAAADoAQAARm9ybXVsYXMvU2VjdGlvbjEubVBLBQYAAAAAAwADAMIAAADHBAAAAAA=\";location=\"AA EXP-1\""}},{"updateDataSourceConnectionString":{"dataSource":"7d542eb2-557a-4f3b-8a99-b7d0f7c25401","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=7fbd0744-b214-4e0e-854c-d5ea6a62e5b7;mashup=\"UEsDBBQAAgAIALmQlk7SJK4hqwAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPTQ6CMBSEr0K657X8iuRRFu6MJCQmxm2DFapQDBThbi48klfQRDHu3M18+RYzj9sd06mpravsetXqhDjAiCV10R6ULhMymKMdkZRjLoqzKKX1knUfT/0hIZUxl5jScRxh9KDtSuoy5tB9ttkWlWwE+crqv2wr3RuhC0k47t5juAvhAgKf+RBEDtIZY6b0nB0IwHOXITCkPxhXQ22GTvKTsNc50rki/fzgT1BLAwQUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAcAFtDb250ZW50X1R5cGVzXS54bWwgohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbY5LDsIwDESvEnmfurBACDVlAdyAC0TB/Yjmo8ZF4WwsOBJXIG13iKVn5nnm83pXx2QH8aAx9t4p2BQlCHLG33rXKpi4kXs41tX1GSiKHHVRQcccDojRdGR1LHwgl53Gj1ZzPscWgzZ33RJuy3KHxjsmx5LnH1BXZ2r0NLC4pCyvtRkHcVpzc5UCpsS4yPiXsD95HcLQG83ZxCRtlHYhcRlefwFQSwMEFAACAAgAuZCWTnSqL9UxAgAAqQMAABMAHABGb3JtdWxhcy9TZWN0aW9uMS5tIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAH2SQWsTQRTH74V8h2G97MISmlIELTm0qdUgaGmiHpJQptmXJnR2R2ZmbWoI2AzaBnvwEq1YqmILSg968KJG+2HGXbz1KzibSbaCpXPZ2fdm/v/fe2841EWLBqhkvrm5zFRmijcxAw9FBx+j7ycojwiIzBTSS/V+KjlUvW86eKNdB5J9QNnGGqUb9lKLQLZAAwGB4LZVuF69x4Hx6mPAZJULhgWsb03PVG9Suk4AKdlX8pPqHSn5sqrkzkj2NNp9Fh++qC7TTWBooWg2C8U0r+Rr459tE962HBcFISEuEiwExzWMhnq11AQQGjNF7lSKAvy8ZfKWe7sVeHlrdMyqdSuLWODaWCLe34nfDdX2QPX21PZbJfeVlEo+0ULx4IsWLeM1Xe0yoz4VcAuwpyu1/zV2UWWcnSekVMcEM55PKGsp5lE/fvM19YgOn6e6ZYYD3qDML1AS+kF56yFw+3Imt9Oxfv8YRE+PdfpsuGtYzoZ9y0XFQFydzSYq3e7EXUmt80HJk1FTz2X/vN9LMUpA9KNYoZu6tP9gXQS43kR2Jfr8Kzo9iF8d1/TFK54esz0znbvmolkX5RxnYjgfCroCPn0EnqmK5/R5k0ufV7JE6r+kG3gfkxDsS2h1oxehgUMijOwd7INWmEw5bXeymPFPDQzPGMfWMzPhceBuI2lZEu4IvUEiSeqnluwZ1Cnzxj+kxUXXcYxPKzj3u3CaCSC3xyjaEtoiWyCAAy0wuXxBs+b+AlBLAQItABQAAgAIALmQlk7SJK4hqwAAAPoAAAASAAAAAAAAAAAAAAAAAAAAAABDb25maWcvUGFja2FnZS54bWxQSwECLQAUAAIACAC5kJZOD8rpq6QAAADpAAAAEwAAAAAAAAAAAAAAAAD3AAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQAAgAIALmQlk50qi/VMQIAAKkDAAATAAAAAAAAAAAAAAAAAOgBAABGb3JtdWxhcy9TZWN0aW9uMS5tUEsFBgAAAAADAAMAwgAAAGYEAAAAAA==\";location=在庫"}},

Community Support Team
Community Support Team

Re: "This table is empty" importing from Excel

Hi @avalos ,

By default, PowerBI Desktop will not trace these errors. In this scenario, we need to enable the trace first, then reproduce this problem, after than analysis the log.

Please refer to the following steps enabling the trace: Go to File->Option and settings->Options->Diagnostics, enable tracing. When error occurs, click Open crash dump/trace folder, we wil get the log file.

Snipaste_2019-04-23_10-42-58.png

Best Regards,

Teige

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 112 members 1,137 guests
Please welcome our newest community members: