Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
unknown_anony
Helper II
Helper II

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 

unknown_anony_0-1714026334013.png

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

unknown_anony_1-1714026446010.png

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 3
ChiragGarg2512
Solution Sage
Solution Sage

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.

vanessafvg
Super User
Super User

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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

unknown_anony_3-1714034707702.png

 

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

unknown_anony_2-1714034624410.png

 



Hope this helps.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.