Forum Discussion

Mike1990's avatar
Mike1990
Frequent Visitor
2 years ago

Not all rows in Power automate output

Hi All,   I''m only getting 26K rows instead of the 60K rows what''s in the table from my power bi, what am i doing wrong in the query?   // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({"I...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

How many rows do you get when you run this in the Power BI Desktop DAX Query view?

Mike1990's avatar
Mike1990
Frequent Visitor
2 years ago

Hi lbendlin ,

 

For now it's 26K rows.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    So your query does what you asked it to do but not what you wanted it to do?

    • Mike1990's avatar
      Mike1990
      Frequent Visitor
      2 years ago

      Not really, i asked it to put all the rows in the csv (60K) but it only sends me the 26k of rows?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        You are running a DAX query against multiple tables with oodles of filters.  The query engine will give you the results based on your query.  If you wanted "just the rows of the table" you would have said (for example) 

         

        EVALUATE 'TASK'