PowerBI PRO (Web) consuming data from either from Azure SQL or REST endpoint

v-marcon — Sat, 27 Jun 2020 00:48:48 GMT

I want a visual to update every 10 minutes from a datasource that changes every 6 minutes.

Only PowerBI Desktop consumes from Azure SQL and REST.

PowerBI Pro (web) can scoop datasets from Azure SQL and REST endpoints via 'Apps'.

Can these apps be written in python?

Is there a generic Azure SQL web client app that I can query the private cloud DB?

Re: PowerBI PRO (Web) consuming data from either from Azure SQL or REST endpoint

lbendlin — Wed, 01 Jul 2020 01:25:56 GMT

"I want a visual to update every 10 minutes from a datasource that changes every 6 minutes."

Shannon and/or Nyquist are turning in their grave.

If you get a notification from your data source that it has refreshed you can use Power Automate to initiate the dataset refresh.

If your data source doesn't provide that notification then you can still use a timer in Power Automate as needed.

Keep in mind that refresh requests will fail while a refresh is still in progress.