cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

 

52 REPLIES 52
Anonymous
Not applicable

Hi @mwegener 

 

Here is screenshot

 

2nd stage.png

 

Hi @Giant ,

 

please check which Output you use.

CheckOutput.png

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

 

jasontran
New Member

@mwegener  @Giant 

 

Any tips on configuring to ensure the flow is triggered everytime the dataset is refreshed? 

I've also set up a scheduled refresh (multiple times daily) on the dataset via the Power BI service but its not triggering the flow unless I test it. 🤔

@mwest Wouldnt a data alert trigger a separate flow to the original web service conifgured?

Hi @jasontran ,

 

can you give an overview of your entire concept / process?

 

@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 

 

flow.png

Hi @jasontran ,

 

is the service refresh executed without errors?

 

@mwegener No errors

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

DeepakSavanur_0-1616763890954.png

 

Hi @DeepakSavanur , what kind of scenario are you trying to achieve?

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

https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or...

 

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-increment...

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,321)