Uploaded September 2024 | Updated September 2026, 2 weeks ago

---

How to use Power Automate to extract Data from Power BI and create a CSV file on SharePoint AND how to update an Excel table with a measure (Last Refresh Date) value.


The 2 bits of code I used

concat('Dataset Export ', formatDateTime(utcNow(), 'yyyyMMMdd'), '.csv')


first(skip(split(string(outputs('CreateCSVTable')), '\r\n'),1))


The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
wyn.bio.link