Share
Report
22Alright, so a bit of background information. I have a power automate flow that runs a query against a Power BI Dataset and then fills up the result on an excel sheet.
I generated the PBI Query by going into the desktop file, selecting the visual and exporting the query from performance analyzer. It works really well. My issue is, the underlying DAX of visual uses the TODAY() function. e.g. calculating where DATESBETWEEN(Dimdates[date],TODAY(),TODAY()+7)
Now, the issue with this, I want to run it on the evening PST time, however, it becomes past midnight in UTC time. So this query is actually giving me result for one day ahead because power automate seems to be in UTC time. How can I address this issue? Is there a way to change timezone for power automate. I could change the query, but I'll have to do it in a significant volume.
All responses (
Answers (
