I'm very new to Power Automate but typically uses Power BI and I have a couple of questions. I've been trying to save the solution to a DAX expression in power bi as that solution changes everytime the dataflow is updated but I found that might be impossible to do. I stumbled on the idea of using Power Automate to store the solution in an excel workbook, google sheets, or a sharepoint list.
Would it be possible to use Flow to automatically update the work book with new solutions daily or even weekly while also keeping the previous solutions in that workbook? If so, how would that be done?
If my question isn't clear, lets think about it this way; imagine in an office of about 500 people, various people open tickets for the IT department to solve issues. The data of the status of each request is recorded and now in Power BI we try to visualize this data and end up writing a dax to count the number of requests that are still open. But this number is subject to change everyday as the IT departments either closes a couple in one day or receive more another day.
So would there be a way to store that number from the previous day so we can track the change in number of open cases? CanI use power automate for this? If so, how?
Thanks @lbendlin. The dax query is written in Power BI and I'm attempting to use the power automate visual to store the dax results. So far I've tried to create flows to google sheets but it keeps failing. Tried sharepoint and excel too but I can't find the sites and folders to complete the flow so google shhets was the only one I could use to finish creating the flow.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!