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
Highlighted
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

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=在庫"}},

Highlighted
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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 115 members 1,569 guests
Please welcome our newest community members: