csv Import Error - This table is empty

[Miguel_Rojo]

Hi Community!

I'm recently expierencing an import error when trying to connect to a csv Sharepoint file.

Here a detail description, hope you can help me:

• In power Bi desktop, I made a connection to a csv in the cloud (SharePoint) using the "web method" (See Screenshot 1)
  • This is a heavy csv (around 3 Million rows, 500 MB)

Once the dataset was imported, in Power Query I performed transformations: (creation of extra column, merge left join, etc.)

At first, I had no problem with the connectivity to the csv, or with the loading of the data.

• However, a few days later I started experiencing the following error:  "This table is empty" (See Screenshot 2)

Power Bi said that my csv did not contain any data (which is an absolute error, because it indeed contains data), and consequently, the following Power Query transformations gave an error (because the reference columns were empty – See Screenshot 3):

• If I click on "Refresh Preview" all the information is loaded, but an "Unexpected Error" message appears in each of the columns. (Screenshot 4 & 5)

Do you know what’s causing it, and what can be done to fix this error?

(I’d really appreciate your support in this subject)

[Anonymous · Accepted solution]

Hi @Miguel_Rojo 

From the last screenshot, it seems the columns are populated with the preview data after refreshing preview. Please open Column quality feature from View ribbon and check if there are some error values in the columns. If no error there, perhaps you can ignore the "Unexpected Error" message and try to close and apply the changes to Power BI Desktop. If there are some errors on specific rows, can you go to an error and find if there is any detailed error message there?

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Anonymous · Accepted solution]

Hi @Miguel_Rojo 

From the last screenshot, it seems the columns are populated with the preview data after refreshing preview. Please open Column quality feature from View ribbon and check if there are some error values in the columns. If no error there, perhaps you can ignore the "Unexpected Error" message and try to close and apply the changes to Power BI Desktop. If there are some errors on specific rows, can you go to an error and find if there is any detailed error message there?

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Miguel_Rojo · Accepted solution]

Hi @Anonymous 

Thanks for your support in this matter.

The "Show Column Quality" option cannot be displayed: instead of getting the standard metrics of "valid, error and empty", the message "An unexpected error occurred" is displayed.

Something absurd happened: I re-entered the authentication credentials ("Organizational - User Email", because it connects to a csv stored in SharePoint), and the problem was resolved. It doesn't make much sense, since I had previously entered them, but it worked.

I appreciate the attention provided,

Regards