Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Automatic refresh of dynamic iterating web datasource

Hi.   I have a query in PBI Desktop that creates a list; 1..150, then iterates over a webpage and adds/expands the corresponding pages. I manually refresh the data in this pbix file every second da...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Please try below ways:

  1. Power Automate: Create a flow that triggers your Power Query script on a schedule and stores the result in a static data store which can then be accessed by Power BI.
  2. You can consider using the combination of Windows Task Scheduler and PowerShell scripts to automate the refresh of a PBIX file.

         Here is a broad outline of the steps you would take:

  • Write a PowerShell script that opens Power BI Desktop, refreshes the data, and publishes the report to Power BI Service.
  • Schedule the PowerShell script using Windows Task Scheduler to run at your desired frequency.

Please note that automating tasks using scripts and Task Scheduler can be complex and may require troubleshooting to ensure reliability.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi both,

 

Honestly I had hope for a much simpler solution to this rather simple task 😞

 

That said I have managed to schedule an attended flow that works (still struggling with the unattended one) in Power Automate. This required more steps both in PA and local system settings, than I can reproduce here, but hopefully it will be easier down the line, or maybe even the Desktop/Service query engines will be identical eventually...