Forum Discussion
Storing Tables with Calculated Columns as Static Tables
Short answer is no. Power BI has no memory.
Long answer: You can run DAX queries against a semantic model, even from within the Power Query Editor of that same semantic model. That is called Self Referencing. Use at your own risk. You will get a giant headache when you think about it too much. There is also no safety net.
Hi, atikahmd
Thanks for the reply from lbendlin , please allow me to provide addition:
Using Power Automate to export data to Excel, you can set up a process to export data to Excel. You can use the “Export to Excel” action to save your data to a specified location. You can check the following link:
How to export data in Power Automate to an Excel File
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I managed to export data to Excel; however, linking the trigger to a Power BI alert has been an issue. Thanks for sharing the link.