topic Re: Extract data from a filtered view in Developer

Extract data from a filtered view

gmsalomao2 — Fri, 16 Jun 2023 14:14:42 GMT

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?

Re: Extract data from a filtered view

lbendlin — Sat, 17 Jun 2023 23:13:34 GMT

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

Re: Extract data from a filtered view

MundoInvest — Mon, 19 Jun 2023 02:35:54 GMT

I can use DAX within automation tools?

Re: Extract data from a filtered view

lbendlin — Mon, 19 Jun 2023 11:39:08 GMT

Yes, from SSIS, PowerShell, Power Automate etc.