Unanswered

Power BI table data export in csv to email using Microsoft Flow

(0) Share

Report

Posted on by Community Power Pla...

Hello Expert,

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

Shree

All responses (52)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

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

https://www.thebiccountant.com/2016/02/09/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

https://www.thebiccountant.com/2020/04/13/create-a-load-history-or-stage-in-cds-instead-of-incremental-load-in-power-bi/
Deepaksavanur 4 on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

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
Community Power Pla... on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @DeepakSavanur , what kind of scenario are you trying to achieve?
Deepaksavanur 4 on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

@mwegener is there any other way to do this ..i have corporate restriction to use the http and here is the error
jasontran 8 on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

@mwegener No errors
Community Power Pla... on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @jasontran ,

is the service refresh executed without errors?
jasontran 8 on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

@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
Community Power Pla... on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @jasontran ,

can you give an overview of your entire concept / process?
jasontran 8 on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

@mwest Wouldnt a data alert trigger a separate flow to the original web service conifgured?
Community Power Pla... on at

Like (0)

Report

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @jasontran ,

check Power BI "Data Alerts"

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration