Forum Discussion
SAVING DAX SOLUTIONS IN POWER BI
Hi all,
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 (Still trying to see if this would work. If anyone knows how to do this feel free to address. Thanks).
Would it be possible to store the solutions somewhere in power bi (like a table or so) daily or even weekly while also keeping the previous solutions from the dax expression? If so, how would that be done? Would I need another dax to do so?
If my question isn't clear, I can elaborate better in the comments.
Thanks y'all!
Hi Anonymous ,
Sorry I am defo not a Power Automate guru. Perhaps you can post your flow/question in the Power Automate community and see if they can help you there?
https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
7 Replies
- m_alireza
Solution Specialist
Hi Anonymous ,
What do you mean by "solution"? Do you mean a DAX query? i.e. you wrote something in DAX but it doesnt work after your dataflow is updated?
Can you give more info on what problem you are trying to solve? Why does the "solution" change everytime your dataflow is updated? What do you want to achieve?Ok 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 suject to change everyday as the IT depatments either closes a couple in one day or recieve 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?
Does that make more sense?
- m_alireza
Hi Anonymous ,
What data source are you pulling from? e.g. SQL Server?
This might help achieve what you are looking for:
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
Otherwise, a Power Automate solution may be possible but depends on your data source. I have previously stored ServiceNow data into Dataverse tables using Power Automate so I know it is possible but you will have to research on your specific use case as there is a lot of factors in place.
v-henryk-mstfCommunity Support
Hi Anonymous ,
Whether the advice given by m_alireza has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry