Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a dataset around 50K rows and there is a column called "Description" which contains an average of 700 rows per record.So each record will have a long text.
So I dragged a table visual and dropped this column into the table.
Then I went into filter pane and I filtered "description" column with Contains filter and I gave a random keyword like "access" and tried to filter the table.
It takes 12 seconds for the visual to load the results even though I'm using Import Mode.
Is there a way that I can improve the performance so that it loads within 2-3 seconds.
It is shocking for me even the default filter pane is taking more than 10 seconds to load.
When we query this in our data source(GCP) using a SQL query it loads within 2-3 seconds.
So Is there a way for me to improve the performance and reduce the loading time in Power BI
Thanks @amitchandak for the response.
I have tried text slicer visual also.
But there are 2 issues:
1. When I type in a keyword, it takes more than 15 seconds to load because each record has minimum 600 words because its a call center conversation data
2. When I publish this in Power BI Service, the text slicer visual itself takes lot of time to load because the column contains so many words.
I was just thinking if we could reduce the load time from 15 seconds to 5 seconds.
If this is something that Power BI Cannot do we need to look at some other options.
Let me know your thoughts @amitchandak
@Imagauthamam , Are you using text filter slicer?
If not try that
Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |