Forum Discussion
Automatically Split One Table into Smaller Tables based on a row value (Name)
Hello, I am working with a dataset with 15mm+ rows, so needless to say I am running into issues while writing some formulas. I have found if I make the data set smaller the formulas work. S...
Hi,
You can create 4 different queries with each having its own 'name' filter, so for instance Query 1 is filtered to 'Dave' alone, and you can do this for other queries as well.
Alternatively, you can reduce the amount of data you work with in the Power BI desktop that won't affect performance then expand the data to the full scope when you publish to the service. This way, you won't need to split the tables. You can see how this works here.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly