Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 possi...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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.