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

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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 310 members 3,456 guests