Word stemming
I'd like to have the ability to perform word stemming without having to use R or Python. When using word clouds, a lot of processing is lost in similar words or synonyms. It should be able to process this since word stemming is one of the fundamental steps when processing sentences.
performance please
How come I run a simple merge and aggregate on a couple of tables takes forever to complete? I run the exact same transformation in R on a single CPU Core and it takes seconds!!! In Power Query? It's been running for about 15 minetus so far with CPU through the roof on all 4 cores with hyper-thr...
Single object vs. multiple objects
In Power Query, I never understood the logic behind the usage of single usage objects and have it store its result and make it reusable throughout the script. It leads to problems when changing source's format. I'm thinking about switching back to R for data transformation. I have been working ...
Locked filters should not be affected by bookmarks filters
Hi, We are currently implementing report in which there are standard filters on certain visuals. Those standard filters are locked and should not be modified by any user. We also use report bookmarks to define preset filtering on multiple columns both on visuals and on pages. The problem comes...
Intellisense is slowing down Power BI??
I was writing some Power Query M code and it occured to me that every now and then, letters were skipped, and intellisense was taking at least 3-5 seconds to show up suggestions. This is really annoying because intellisense is supposed to speed up coding but now it's just holding me back. Even ...
Improve Dataflows script restrictions
Many times I have lost steps instructions because I had to swap windows to copy info from another script and when I came back to the formula, I get a warning about script restrictions and a suggested correction which basically got rid of all the code and made it an empty step.
This is an...
Show table stats on Dataflow entities screen
When clicking on a dataflow to see the underlying entities, I'd like to see each entities statistics like number of rows, and same for each columns (distribution, distinct, unique, min, max, number of values, etc...).
This way I won't have to go in edit mode or to have a desktop report connec...
Make Power Query Quicker!!!!
I can understand why a simple table merge of one-to-one relationship having less than 10 000 records is taking more than a minute to process!!. I could run the same script in 'R' and it would take less then 10 seconds to run it. Honestly, I don't get why it has to go back to the source every sin...
Make better use of caching to speedup development of models
This is coming from past experiences using RStudio and practically any other programming languages. Make it so that when I read the data source on the first step, it will cache the data read and use this cache for future steps instead of downloading a new preview everytime. For example, if I'm ...
Make intellisense more context aware
I believe one of the things I hate the most about intellisense in Power Query is that it show all objects/functions even those unrelated to the context. Example: I begin typing "Text." then it shows me everything. I must not put a dot at the end otherwise it looses context. Any other progr...