Forum Discussion

BharathS1307's avatar
BharathS1307
Frequent Visitor
8 months ago
Solved

Power BI dataflows

Hi All, I am trying to update one of my dataflows  1) There is a step for filtered rows, i.e I am filtering some of the values from a field and then pivoting them then merging them with a dim table...
  • tayloramy's avatar
    8 months ago

    Hi BharathS1307

     

    How much data are you working with? 

    THis type of error generally means that you're trying to process too much data at once. 

     

    Is there any filtering or removing of columns that you can do before the pivot? 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

  • tayloramy's avatar
    tayloramy
    8 months ago

    Hi BharathS1307

     

    GIve it a shot and see what happens. That is the best way to learn. 

     

    Without a clearer understanding of what you're trying to achieve and the structure of the data you're working with, I can't give any specific recommendations. Whatever you do try to filter data early and limit it to only what you need so that the power query engine isn't trying to process all of it at once. 

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.