Forum Discussion
Microsoft EmployeeRefreshed but Still Stale Data Report Needed
Hi GilbertQ, thanks a lot for your answer, however I am unsure if I will be allowed to use/or if we have Power Automate licensing to solve this issue, will check later this week, thanks again! Juan
Super UserHi cerebraino
What you could do is use Power Automate where you can run a DAX query on each table using the COUNTROWS DAX function. You can then export this file to say a CSV file which can be saved into Sharepoint online.
Then you could have a Power BI report which will read those CSV files from Sharepoint online, and you can then create alerts etc based off this dataset.
I have a blog post below on how to get the DAX query, export it to a CSV file in Sharepoint using Power Automate.
Exporting a Power BI Visual data to a CSV File in SharePoint - FourMoo | Power BI | Data Analytics
Microsoft EmployeeHi GilbertQ, thanks a lot for your answer, however I am unsure if I will be allowed to use/or if we have Power Automate licensing to solve this issue, will check later this week, thanks again! Juan