cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
TeigeGao Super Contributor
Super Contributor

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

TeigeGao Super Contributor
Super Contributor

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