Forum Discussion
invoke power query from DAX
I have power query M code that generates the table from JSON input, I am able to load to the DAX using close and apply but I need a way to programatically load the result set from power query to DAX....
This is what Scheduled Refresh does in the service, or the Refresh button in the Power BI Desktop app does. You cannot use DAX to trigger a refresh.
If you want to manually trigger it you could add an Power Platform app visual that will use a Power Automate flow to trigger the refresh, and coming soon is a Power Automate visual for Power BI (soon as in, the tools exist in Power Automate already, but not yet in Power BI, so real soon) that I hope will let you trigger a refresh with a simple button click.
But DAX is just a set of functions for analysis, not for making programming calls.