Forum Discussion

Miguel_Rojo's avatar
Miguel_Rojo
Helper II
2 years ago
Solved

csv Import Error - This table is empty

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 conne...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
    Miguel_Rojo
    2 years ago

    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