Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Measures Not Appearing in Dataset

Hi All,

 

I have a report which uses a Power Apps / Automate button to export data to a csv file. The issue that I have is that calculated measures don't appear in the dataset being sent to Power Automate.

 

The fields used:

 

And the data that's flowing to the flow.

 

 

I've googled the daylights out of it, can't find a reason why they don't flow through.

 

Shane

  • Anonymous's avatar
    Anonymous
    4 years ago

    OK, I eventually found the issue. The problem is the model - the same combination of fields works for a table visual, but not for the Power Automate dataset. Power Automate IS taking calculated measures, but I had to remove a couple of fields from another table to get the PA dataset to work.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    OK, I eventually found the issue. The problem is the model - the same combination of fields works for a table visual, but not for the Power Automate dataset. Power Automate IS taking calculated measures, but I had to remove a couple of fields from another table to get the PA dataset to work.