How Power BI table data export in csv to email using Microsoft Flow as we know it can refersh data sets but how about tables export as email attachment
Hi @Giant ,
please check which Output you use.
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
@mwegener concept is to automate csv data exports to a dedicated sharepoint folder everytime the dataset is refreshed in power bi service.
an addition ive made is build in a datetime stamp against the filename so each refresh will generate a new file but the problem im encountering is a new file isnt being generated even though the underlying dataset is triggered to refresh 3 times/day.
it only appears to work when i test the flow and manually refresh in power bi desktop
I have two excel which will be automatically changed everyday with same columns. I am comparing these two excels and create these logs appended onto a table on power bi.. I was able to compare and create the log but unable to append the everyday logs to a single table. but everytime it refreshes its deleting the old file. i want to check if there is a way using flow or DAX to append the logs
Hi @DeepakSavanur ,
this topic is not easy, because Power BI usually does a full refresh.
Imke Feldmann has made two blog posts on this topic as well. Do you know these blog posts?
How to create a Load History or Load Log in Power Query or Power BI
Create a load history or stage in CDS instead of incremental load in Power BI
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.