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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Send data automatically to Power Automate

Hello,

 

I am having a problem with importing and updating data automatically from Power BI Desktop to Power Automate.
Since I have a dataset that includes a dynamic data source, it is not possible to automatically update it as well as update it in the web view of Power BI.


Is there any way other than the following to import the data to power Automate automatically at best?

 

This is how I currently send my data from Power Bi Desktop to Power Automate:

StreamoJoline_2-1649833505625.png

Pages Power Automate it looks like this:

 

StreamoJoline_3-1649833548795.png

 

Manually I find this process a bit cumbersome as it has to be done at least once each week for multiple reports.

 

I hope someone can help me.

 

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @Anonymous 

 

Which part of the data source is dynamic? Have you tried the Power Query parameter? Sometimes you can parameterize the dynamic parts of the data source. After publishing the report to Power BI Service, you can go to Dataset settings page and change their values there. Next time when you refresh the dataset (manually or at scheduled times), it will use the new parameter values. 

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

How to Parameterize Data Sources in Power BI | Tessellation

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Anonymous
Not applicable

Hello,

I am actually using the power query parameters to retrieve my data source.
However, since my data source has more than 1000 records, I make use of the pagination function (picture 1+2)
Because of this pagination function my data source is dynamic. 

StreamoJoline_0-1652077399124.png

StreamoJoline_1-1652077527907.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors