The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
Pages Power Automate it looks like this:
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.
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.
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.