Extract data from a filtered view

[gmsalomao2]

I want to trigger an automation (Integromat / Make) based on data from a filtered view of a Power BI report page.

The obvious solution would be to calculate everything before writing to the database. So I would trigger the automation based on the data read directly from it.

But I want to be able to use metrics from PowerBI as data source.

And I also want to be able to filter the data before extracting it.

Is that possible?

[MundoInvest]

I can use DAX within automation tools?

[lbendlin]

Yes, from SSIS, PowerShell, Power Automate etc.

[lbendlin]

You can run DAX queries against Power BI datasets.  No need to torture the report.