MENU

Fun & Interesting

Extract Power BI data & measures with Power Automate

Access Analytic 20,210 8 months ago
Video Not Working? Fix It Now

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 https://wyn.bio.link/

Comment