Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MAnvers
Regular Visitor

Power BI export to excel and csv with Power Automate

Hi

In power BI I created an instantflow to export data to excel and cvs file using power BI.

The next step is to schedule an automatic export twice a month. On the 15th and 25th of every month without having to hit the "run" button in PBI.

I know that in power Automate there is an option to create a schedule flow, but I need to this while creating the flow in power BI as shown below.

Is there a way I could do this in Power BI ? 

MAnvers_0-1651415083829.png

Thank you in advance for your feedback. 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Create/use a custom connector that allows you to run the datasets/xxx/executeQueries  API call.

 

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

 

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Create/use a custom connector that allows you to run the datasets/xxx/executeQueries  API call.

 

Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.