Forum Discussion

unknown_anony's avatar
unknown_anony
Icon for Helper II rankHelper II
2 years ago

Text analysis in power bi

Hello All,
Thank you for all your support in past,
I am working on the text analysis on one of my dashboard. I has 29 lakh rows. I was getting the below erroer 

so i removed the error and applied text analysis on the file.

it is since 2 hrs the data is not loading,
Is it something i am missing or it is to much for bi to do the text analysis on such a huge dataset?

Thank you

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    you will need to provide more inforrmation around what you are doing?  can you share your steps.

     

    also what method are you using to connect to sharepoint, file via web or folder via sharepoint

    • unknown_anony's avatar
      unknown_anony
      Icon for Helper II rankHelper II

      Hello,
      The datasource is folder in sharepoint
      Below are appalied steps

       

      after that i am using text analysis in one of the description column of the dataset.
      Below is the result, 
      but it is not loading to frontend

       



      Hope this helps.

  • Go to File -> Options and Settings -> Data Source settings -> Select the data source and "Edit Permissions" -> Change the Privacy Level.

     

    Also try uploading the data again via power query.