Forum Discussion

gmsalomao2's avatar
gmsalomao2
New Member
3 years ago

Extract data from a filtered view

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?

 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Yes, from SSIS, PowerShell, Power Automate etc.