News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Scheduled flow to extr...

Dynamics 365 general forum

Suggested answer

Scheduled flow to extract data from Power Bi report

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I need to build a Power Automate flow that extracts data from a Power Bi report (csv or xlsx) and places the extract in a Sharepoint folder.

The flow should be launched automatically every day.

I have already created a button in the Power Bi report. When we click on this button, an extract is placed in the Sharepoint folder,

but I don't know how to make this flow a scheduled flow.

Can you please help me to find a solution for this flow ?

Thank you in advance

Categories:

Dynamics 365 Administration

All responses Img

All responses (3)

Answers Img

Answers (0)

alen1979 725 on at

Like (0)

Report

RE: Scheduled flow to extract data from Power Bi report

Hi sarraHa

Have you found a solution for this in the meantime? I'm trying to achieve the same thing (i.e. have automated export of PowerBI to a .csv file)
Community Member Microsoft Employee on at

Like (0)

Report

RE: Scheduled flow to extract data from Power Bi report

Hello @Kenneth Chaves

Thank you for your response.

This does not help me because I need to export data in csv or xlsx format and not in png format as indicated in the first link.

manually, we can export data like this:

But I need to do it automatically with a Power Automate flow for example.
Suggested answer

Kenneth Ariel Chave... on at

Like (0)

Report

RE: Scheduled flow to extract data from Power Bi report

Hi,

There is an effortless way to implement what you are looking for:

Automatically export Power BI Reports to files in SharePoint using Power Automate - michelcarlo

Here documentation related to creating a scheduled flow:

Run flows on a schedule - Power Automate | Microsoft Docs

If this was helpful, please check it as verified to help others finding useful information.

Welcome to this amazing community.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,645 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans